Subject | SQL SELECT problem |
---|---|
Author | Philip A. Stephens |
Post date | 2003-03-13T08:50:06Z |
The following statement works in IBAccess EXEC-SQL but fails in IBOConsole
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.
TIA -Phil Stephens
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.
TIA -Phil Stephens