Re:delphi-oracle

From: <dgoulet_at_vicr.com>
Date: Thu, 7 Dec 2000 08:53:48 -0500
Message-Id: <10703.123918@fatcity.com>

Old problem, simple solution, enclose the table names in double quotes as in:

select * from "emp";

vs.

select * from emp;

    By it's very nature Oracle stores all object names in uppercase & maintains a "case insensitivity", until you introduce it by:

    create table "emp"();
or

    create table "Emp"();

Dick Goulet

____________________Reply Separator____________________

Subject: delphi-oracle
Author: GKor_at_rdw.nl
Date: 12/7/2000 12:26 AM

hi everyone

Has anyone of you problems with lowercase table names coded in Delphi 4 and you get the
message :
 ORA-00942: table or view does not exist" if you query this on oracle ?

thanks
g.g. kor
rdw the netherlands

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: GKor_at_rdw.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 07 2000 - 07:53:48 CST