Subject | Re: [IBO] SQL SELECT problem |
---|---|
Author | Helen Borrie |
Post date | 2003-03-13T08:58:12Z |
Phil,
At 07:50 PM 13/03/2003 +1100, you wrote:
Helen
At 07:50 PM 13/03/2003 +1100, you wrote:
>The following statement works in IBAccess EXEC-SQL but fails in IBOConsoleCould you describe how the first query fails? Exception? No data? or ???
>or in My Delphi 5 App using an IBOQuery against Firebird 1.0.
>
>'SELECT FIRST 10 * FROM FCDX_ZONES WHERE ADDRESS CONTAINING '01-' ORDER BY
>ADDRESS'
>
>I am new to Firebird and cannot find any indication of problems with the
>query in the docs BTW
>
>'SELECT * FROM FCDX_ZONES WHERE ADDRESS CONTAINING '01-' ORDER BY ADDRESS'
>
>Works fine in all cases.
Helen