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_at_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_at_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_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).
>> >
>> >
>> ---
>> 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_at_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_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).
>--
>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).
>
>

---
Dennis Taylor
---
Don't worry about people stealing your ideas.  If your ideas