At 05:14 PM 2/24/03, you wrote:

>Hello Jason & All,
>
>If you put in a IBOQuery a wrong SQL like :
>
>SELECT * FROM MY_TABLE
>ORDER BY DESCR DESC
>WHERE COD LIKE 'XX%'

I does the same thing in the designed in version 4.2gA. It gives an error
without the DESC.

>the query parser doesn't raise an exception (the ORDER can't preceed the WHERE
>clause).
>The WHERE clause is simply TRUNCATED and the query fetches all records.
>
>Any tought ?

Don't make that mistake?

>Best regards,
>
>Ing. Guido Salvestroni
>CONSIST Srl.
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Ross Williams
Citizens for Sensible Transportation/
Coalition for a Livable Future
Terminal Sales Building
1220 SW Morrison, Suite 535
Portland OR 97205

Phone: 503-225-0003
Fax: 503-225-0333
Web: www.cfst.org
Email: ross@...