Subject | Dangerous query behaviour - IBO 4.2.Ib |
---|---|
Author | Guido Salvestroni |
Post date | 2003-02-25T01:14:02Z |
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%'
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 ?
Best regards,
Ing. Guido Salvestroni
CONSIST Srl.
If you put in a IBOQuery a wrong SQL like :
SELECT * FROM MY_TABLE
ORDER BY DESCR DESC
WHERE COD LIKE 'XX%'
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 ?
Best regards,
Ing. Guido Salvestroni
CONSIST Srl.