Ann,
Thank you again for your reply and direction on the case name for the
table. What of the field/column names? Should they also be upper case
for FB? Is there also a difference between FB and Postgre in this regard?

TY
Tim

On 1/31/2011 10:58 AM, Ann W. Harrison wrote:
>
> 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
>
>


[Non-text portions of this message have been removed]