Phil,

What about some garbage in Keylinks, OrderingLinks or OrderingItems?

Try use IB_SQL. In Query Forms, launch a new query and enter your sql and
see what happend.

Luiz.

----- Original Message -----
From: "Philip A. Stephens" <pstephen@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 14, 2003 10:32 AM
Subject: RE: [IBO] SQL SELECT problem


> the following (typed directly into interactive SQL in IBOConsole) returns
9
> rows:
>
> SELECT * FROM FCDX_ZONES WHERE DESCRIPTION CONTAINING 'A14' ORDER BY
> DESCRIPTION
>
> changing this to:
>
> SELECT FIRST 5 * FROM FCDX_ZONES WHERE DESCRIPTION CONTAINING 'A14' ORDER
BY
> DESCRIPTION
>
>
> results in (Cut and paste this time):
>
> <<ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 2, char 6
> ,
>
> STATEMENT:
> TIBOInternalDataset:
> "<TApplication>.frmMain.dlgWisql_3.<TIBOQuery>.<TIBOInternalDataset>."
>
> Statement: SELECT FIRST 5 * FROM FCDX_ZONES WHERE DESCRIPTION CONTAINING
> 'A14' ORDER BY DESCRIPTION >>