Write an SQR condition statement - Stack Overflow SQR is quite a nice finite language to learn - syntax somewhat strict, but simple as Basic with SQL I do recommend reading the reference manual - it's downloadable from Oracle Feel free to ask any other questions about SQR - I get alerts if you do - sorry it took this long to answer
Get number of records returned from select in SQR I have an SQR Begin-Select statement which SELECTS a bunch of data and returns it for processing the SQR report There is a possibility that the Begin-Select will return nothing, so that means there is nothing to report How would I check if the Begin-Select returns no rows in it's statement
sqr - Addressing both commas and double quotes in a CSV - Stack Overflow I am writing a report in SQR which produces a CSV output file While testing, I ran into an instance where the following string is used in one of my fields: TABLE - 210" X 60" X 29", OAK, I currently have double quotes surrounding the string When I use this method, the output produced is this: Col 1 |Col 2|Col 3
SQR procedure with run-time error on BEGIN-SELECT statement You say this is pseudo code - if it were real code, SQR would have a problem with the do Insert-TableA-Record and do Insert-TableB-Record being in column 1 Is this close to real code? A EMPLID in the begin-select statement in procedure Insert-TableA-Record should be in column 1 Is there any way to see portions of the real code? –
SQR - how to use FROM [dynamic table name} within BEGIN-SELECT? I have to create an SQR that generates a list of EEIDs, if there were any changes to the Pension data in the past day The SQR compiles and works perfectly when I hardcode in the table names Howev