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

[Ray Ontko <rayo@ontko.com>]

Matt,

Are you sure that the problem is being caused by the 
[$blah]?   What happens if you replace in your SQR
program the [$blah] with the actual text?  That is,
if you hard-code what you want, do you still get the
error?  If your syntax is otherwise correct, then 
you should be able to put the exact text as the value
of $blah and replace the text with [$blah].

I have never had a problem with [$blah], except ONE
instance similar to Jim's where it helped to put a
[$dummy] (where $dummy has been assigned the empty
string) at the beginning of the FROM clause.  For 
example:

move '' to $dummy
begin-select
...
FROM
  [$dummy]
  my_table, ...
WHERE
  ...
end-select

Hope this helps.

Ray

On Fri, Mar 12, 2004 at 09:12:52AM -0500, Matt Rogish wrote:
> 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
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

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