On 1/31/2011 12:29 PM, Tim Seyfarth wrote:

> Hello Thomas.
>
> Yes, axcys is a schema. I removed the word to now use this command
> DatabaseQuery(1, "SELECT * FROM contacts;") ... Why does TB
> think there is no contacts Table?
>

You've got yourself tangled up with quoted names and the folding
of non-quoted names to a single case. Firebird (and the SQL
standard) fold to upper case. PostgreSQL folds to lower. So,
in Firebird, if you define a table as

CREATE TABLE "contacts"

you must always quote the name in queries

SELECT * FROM "contacts"

but if you define a table as either

CREATE TABLE CONTACTS ...
or
CREATE TABLE "CONTACTS"

you can reference it as

SELECT * FROM contacts
SELECT * FROM Contacts
SELECT * FROM CONTACTS

Good luck,

Ann