Subject | parameterized SELECT statement error: token unknown |
---|---|
Author | phoove27 |
Post date | 2002-04-01T19:45:16Z |
I am using Firebird 1.0 for Linux and Delphi 6.0 (with 2nd bug fix)
for Windows XP. The problem also appears when I use the Interbase
6.0 that shipped with Delphi.
Can anyone determine from the SQL Monitor output why I am
getting the following error message:
token unknown - line 1, char 48
OPTION
SQL Monitor output:
INTERBASE - isc_attach_database
INTERBASE - isc_dsql_allocate_statement
INTERBASE - isc_start_transaction
select * from VENDOPTS
INTERBASE - isc_dsql_prepare
INTERBASE - isc_dsql_describe_bind
INTERBASE - isc_dsql_execute
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_allocate_statement
SELECT 0, '', '', A.RDB$RELATION_NAME,
A.RDB$INDEX_NAME,
B.RDB$FIELD_NAME,
B.RDB$FIELD_POSITION,
'', 0, A.RDB$INDEX_TYPE, '',
A.RDB$UNIQUE_FLAG,
C.RDB$CONSTRAINT_NAME,
C.RDB$CONSTRAINT_TYPE
FROM RDB$INDICES A,
RDB$INDEX_SEGMENTS B
FULL OUTER JOIN RDB$RELATION_CONSTRAINTS C ON
A.RDB$RELATION_NAME = C.RDB$RELATION_NAME AND
C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
WHERE (A.RDB$SYSTEM_FLAG <> 1 OR A.RDB$SYSTEM_FLAG IS NULL) AND
(A.RDB$INDEX_NAME = B.RDB$INDEX_NAME) AND
(A.RDB$RELATION_NAME = UPPER('VENDOPTS'))
ORDER BY RDB$INDEX_NAME
INTERBASE - isc_dsql_prepare
INTERBASE - isc_sqlcode
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_commit_retaining
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_allocate_statement
select * from VENDCOPT where VEND_ID = ? and OPTION = ?
INTERBASE - isc_dsql_prepare
INTERBASE - isc_sqlcode
INTERBASE - isc_commit_retaining
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_free_statement
Thanks,
Paul
for Windows XP. The problem also appears when I use the Interbase
6.0 that shipped with Delphi.
Can anyone determine from the SQL Monitor output why I am
getting the following error message:
token unknown - line 1, char 48
OPTION
SQL Monitor output:
INTERBASE - isc_attach_database
INTERBASE - isc_dsql_allocate_statement
INTERBASE - isc_start_transaction
select * from VENDOPTS
INTERBASE - isc_dsql_prepare
INTERBASE - isc_dsql_describe_bind
INTERBASE - isc_dsql_execute
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_allocate_statement
SELECT 0, '', '', A.RDB$RELATION_NAME,
A.RDB$INDEX_NAME,
B.RDB$FIELD_NAME,
B.RDB$FIELD_POSITION,
'', 0, A.RDB$INDEX_TYPE, '',
A.RDB$UNIQUE_FLAG,
C.RDB$CONSTRAINT_NAME,
C.RDB$CONSTRAINT_TYPE
FROM RDB$INDICES A,
RDB$INDEX_SEGMENTS B
FULL OUTER JOIN RDB$RELATION_CONSTRAINTS C ON
A.RDB$RELATION_NAME = C.RDB$RELATION_NAME AND
C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
WHERE (A.RDB$SYSTEM_FLAG <> 1 OR A.RDB$SYSTEM_FLAG IS NULL) AND
(A.RDB$INDEX_NAME = B.RDB$INDEX_NAME) AND
(A.RDB$RELATION_NAME = UPPER('VENDOPTS'))
ORDER BY RDB$INDEX_NAME
INTERBASE - isc_dsql_prepare
INTERBASE - isc_sqlcode
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_dsql_fetch
INTERBASE - isc_commit_retaining
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_allocate_statement
select * from VENDCOPT where VEND_ID = ? and OPTION = ?
INTERBASE - isc_dsql_prepare
INTERBASE - isc_sqlcode
INTERBASE - isc_commit_retaining
INTERBASE - isc_dsql_free_statement
INTERBASE - isc_dsql_free_statement
Thanks,
Paul