Somehow I lost track of the statement you had which caused these errors.
Please send it to me again. Privately is fine.

Jason Wharton

----- Original Message -----
From: "Jeroen W. Pluimers (mailings)" <jeroen.mailings@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, August 30, 2001 5:21 AM
Subject: RE: [IBO] IBO 3.6 query parser makes mistakes with comments


> > I use comments in my SQL all the time and have never encountered
> > a situation where the parser did anything with them except what
> > is expected.
>
> As soon as I remove the comments in the ORDER BY, then it starts working
> correctly. So I really presume it has something to do with the ORDER BY
> parsing.
>
> > What the monitor is spitting out is alphabet soup, since your
> > statement is "unparsable" in the pieces which the IBO parser
> > plays with (join criteria, parameters and the WHERE clause).
>
> That is what I figured. If what you say is true, then IBO is the first
tool
> that dislikes the 1=1 syntax.
>
> Let's wait on what Jason has to tell about this.
>
> --
> Jeroen W. Pluimers
> Consultant at All I M
> http://www.all-im.com