Page 1 of 1

Quotes sometimes required

Posted: Mon 12 May 2008 14:01
by dennis
I am using IBAC 2.20.0.12 for RAD Studio 2007. Firebird Embedded v2.0
I have noticed that when using IBCTable, that the list of table names in the database comes up in the 'table' property of the Object Inspector but when I try to activate the IBCTable component, I get 'Table not found'. This does not happen with system tables.
If I then specify "tablename", (with double quotes around the table name), all is OK.
This also happens with field names in SQL statements generated.

Is this expected?

Dennis

Posted: Tue 13 May 2008 08:33
by Plash
Quotes are required if table name or field name contains characters in lower case or special characters.

Posted: Tue 13 May 2008 13:52
by dennis
Thanks, Plash. Silly me. I guess I'm still a newbie!

Cheers