Subject Re: [IBO] IBO 3.6 query parser makes mistakes with comments
Author Jason Wharton
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: <>
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
> 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