Subject TIBOTable and field names that require quoting.
Author mspencewasunavailable
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.