[sqr-users] RE: Replacement Variables and Oracle 9i "IN" clause

[Matt Rogish <rogishmn@muohio.edu>]

All,

Thanks for the suggestions, but none of them seemed to work: the error was 
not that the values were being garbled or otherwise parsed incorrectly but 
that SQR was prematurely terminating the SQL when it sent it off to Oracle 
to prepare/compile.

(I already had an example with the parens in the quotes, they are int 
values so quoting them would not work, and since they are entered from the 
user I can't unstring since there are a variable number of them).

Even Jim's suggestion of doing WHERE [$ASpace] didn't seem to work.

This is really frustrating but I cannot find any SQR documentation that 
suggests how the [$..] logic is supposed to work (namely is this a bug or 
intended functionality?)

The same behavior exists in Brio version 6 *and* 8.2.

Thanks,

--
Matt


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users