Subject | TIBOTable and field names that require quoting. |
---|---|
Author | mspencewasunavailable |
Post date | 2006-09-26T15:12:26Z |
I've found another instance where this runs aground.
I have a table named SCHED$ which has a number of fields, but two of
them are "Acc ID" and "Serv ID". This table has a master table
which contributes values for these two fields so that the
corresponding data can be located. This seems to be handled by
adding a WHERE clause with appropriate params. But the SQL
generated doesn't account for the quoting on the fields, so I get
this error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 42
ID
and this SQL:
SELECT ALL SCHED$.*
FROM SCHED$
WHERE SCHED$."Acc ID" = ? /* Acc */ ID
AND SCHED$."Serv ID" = ? /* Serv */ ID
ORDER BY SCHED$."Acc ID" ASC
, SCHED$."Serv ID" ASC
I'm going to try to work around this, but I thought you'd like to
know.
Michael D. Spence
Mockingbird Data Systems, Inc.
I have a table named SCHED$ which has a number of fields, but two of
them are "Acc ID" and "Serv ID". This table has a master table
which contributes values for these two fields so that the
corresponding data can be located. This seems to be handled by
adding a WHERE clause with appropriate params. But the SQL
generated doesn't account for the quoting on the fields, so I get
this error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 42
ID
and this SQL:
SELECT ALL SCHED$.*
FROM SCHED$
WHERE SCHED$."Acc ID" = ? /* Acc */ ID
AND SCHED$."Serv ID" = ? /* Serv */ ID
ORDER BY SCHED$."Acc ID" ASC
, SCHED$."Serv ID" ASC
I'm going to try to work around this, but I thought you'd like to
know.
Michael D. Spence
Mockingbird Data Systems, Inc.