Is there anywhere in the docs that says we should not use an 
underscore in a table name?

table  FC_Client_Info exists with a record where jobno 1234 has 
info:

select acode from FC_Client_Info where jobno = '1234';
fails with a warning that fc_client_info does not exist
notice the lower case. If I quote the table

select acode from "FC_Client_Info" where jobno = '1234';
the select works fine

What's the problem here? This should be easy.

Ted


Reply via email to