I will need to update IBO's parsing to allow for this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, December 11, 2001 11:01 AM
Subject: [IBO] Cursors and SQL parsing...


> Hi,
>
> I've noticed that when IBO opens a cursor (whatever component) it parses
the
> SQL quite a lot.
>
> Executing the following statement in IBO (IB_ISQL):
>
> select * from employee
> order by emp_no asc 423423
>
> Succeeds just fine. The statement that goes to the server is:
>
> select * from employee
> order by emp_no asc
>
> Obviously, this can be a problem with IB6.5, a query like this:
>
> select * from employee
> order by emp_no asc
> rows 1 to 5
>
> goes to the server like:
>
> select * from employee
> order by emp_no asc
>
>
> Comments anyone?
> --
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."