Quotes sometimes required

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dennis
Posts: 10
Joined: Tue 23 Oct 2007 14:10

Quotes sometimes required

Post by dennis » Mon 12 May 2008 14:01

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
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 13 May 2008 08:33

Quotes are required if table name or field name contains characters in lower case or special characters.
Top
dennis
Posts: 10
Joined: Tue 23 Oct 2007 14:10

Post by dennis » Tue 13 May 2008 13:52

Thanks, Plash. Silly me. I guess I'm still a newbie!

Cheers
Top
Post Reply

Return to “InterBase Data Access Components”