Article View: borland.public.cppbuilder.database.ado
Article #3002Wrong field names returned
From: Clayton Arends
Date: Tue, 21 Jan 2003 21:15
Date: Tue, 21 Jan 2003 21:15
28 lines
2232 bytes
2232 bytes
All, I have quite an intriguing issue on one of my test databases that I am hoping someone can shed some light on. I don't know if the database type is part of the issue but I am using Oracle (via ADO, of course). I have tried a variety of connection strings and connection types and my "quirky" situation persists. I have created a test table named TESTER with two fields named FIELD1 (varchar2) and FIELD2 (integer). When I perform "select * from tester" the results I receive are correct but the names of the fields are FIELD1_1 and FIELD2_2. If I use an Oracle tool the field names are returned correctly ... this only happens via the ADO connection. I have created other tables without problem. Another problem I have, which only happens to this table, is if I try to perform a DELETE FROM or UPDATE query then the connection will hang. SELECT and INSERT INTO work just fine. This only happens on this one table ... every other table works just fine for all 4 query types. Just hoping someone might have a clue what is going on here. Obviously this doesn't really affect my actual coding since I would never use FIELD1 and FIELD2 in a legitimate database. TIA, - Clayton
Technical Details
Message-ID:
<3e2db874$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,6f94352be634b33d,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-01-21 13:21:32 PST From: "Clayton Arends" <claytonarends@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Wrong field names returned Date: Tue, 21 Jan 2003 13:15:33 -0800 Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 24.30.133.15 Message-ID: <3e2db874$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1043183732 24.30.133.15 (21 Jan 2003 13:15:32 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail