Message-Id: <10706.124144@fatcity.com> From: GKor@rdw.nl Date: Sun, 10 Dec 2000 09:12:17 +0100 Subject: RE: delphi-oracle we can access the table lower- and uppercase in sqlplus, only Delphi makes single quotes around tables and if it thats not uppercase, the table won't be found. > -----Oorspronkelijk bericht----- > Van: Dennis Taylor [SMTP:ismgr@pctc.com] > Verzonden: 8-dec-00 16:46 > Aan: Multiple recipients of list ORACLE-L > Onderwerp: RE: delphi-oracle > > can you access the table normally using sqlplus? I'm thinking of the > possibility that the table was created with name in quotes and actually > contains some lower-case letters. > > Can you display the whole sql statement before executing it? In DOA, for > instance, there's a DEBUG property that displays any sql stmt before > execution. That's cleared up many a problem for me. > > > At 02:40 AM 12/8/00 -0800, you wrote: > >we are using BDE to connect to Oracle > > > >> -----Oorspronkelijk bericht----- > >> Van: Dennis Taylor [SMTP:ismgr@pctc.com] > >> Verzonden: 8-dec-00 04:28 > >> Aan: Multiple recipients of list ORACLE-L > >> Onderwerp: Re: delphi-oracle > >> > >> No, in fact we generally have everything in lower-case (except stuff in > >> quotes) and it works fine. > >> > >> What are you using to connect from Delphi to Oracle? odbc? BDE? DOA? > >> > >> At 12:26 AM 12/7/00 -0800, GKor@rdw.nl wrote: > >> >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@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@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). > >> > > >> > > >> --- > >> Dennis Taylor > >> --- > >> Don't worry about people stealing your ideas. If your ideas > >> are any good, > >> you'll have to ram them down people's throats. > >> -- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.com > >> -- > >> Author: Dennis Taylor > >> INET: ismgr@pctc.com > >> > >> 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@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). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: > > INET: GKor@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@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). > > > > > --- > Dennis Taylor > --- > Don't worry about people stealing your ideas. If your ideas > are any good, > you'll have to ram them down people's throats. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dennis Taylor > INET: ismgr@pctc.com > > 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@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