🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3002

Wrong field names returned

#3002
From: Clayton Arends
Date: Tue, 21 Jan 2003 21:15
28 lines
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-mail

Show 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