| Subject | RE: [IBO] SQL SELECT problem |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-03-13T22:08:15Z |
your statement is delimited by single quotes and so too is your string for
containing.. this will not work
-----Original Message-----
From: Philip A. Stephens [mailto:pstephen@...]
Sent: Friday, 14 March 2003 8:42 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] SQL SELECT problem
Sorry:
I get
"Dynamic SQL Error
SQL Error code = -104
Token Unknown - line 2, char 6
'
"
(the above could be ',' but it is hard to tell, it is on a line by itself)
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 13 March 2003 19:58
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] SQL SELECT problem
Phil,
At 07:50 PM 13/03/2003 +1100, you wrote:
Helen
___________________________________________________________________________
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/
___________________________________________________________________________
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/
containing.. this will not work
-----Original Message-----
From: Philip A. Stephens [mailto:pstephen@...]
Sent: Friday, 14 March 2003 8:42 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] SQL SELECT problem
Sorry:
I get
"Dynamic SQL Error
SQL Error code = -104
Token Unknown - line 2, char 6
'
"
(the above could be ',' but it is hard to tell, it is on a line by itself)
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 13 March 2003 19:58
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] SQL SELECT problem
Phil,
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
___________________________________________________________________________
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/
___________________________________________________________________________
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/