Subject Re: [ib-support] parameterized SELECT statement error: token unknown
Author Daniel Rail
At 01/04/2002 03:45 PM, you wrote:
>token unknown - line 1, char 48
>select * from VENDCOPT where VEND_ID = ? and OPTION = ?

OPTION is a reserved word. So, you'll need to put the field OPTION in
quotation marks (i.e. "OPTION"). The best practice is to try to avoid
reserved words. You can find them in the IB 6 Beta documentation Language
Reference volume.

Use the following SQL statement as example:
select * from VENDCOPT where VEND_ID = ? and "OPTION" = ?

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (