Article View: borland.public.cppbuilder.database.ado
Article #4855Re: Oracle RowID
From: Jari Kettunen
Date: Wed, 19 Sep 2001 07:07
Date: Wed, 19 Sep 2001 07:07
34 lines
1973 bytes
1973 bytes
As everyone know rowid is unique field in every Oracle table row and you can
access it same way as normal fields.
Problem was that following code didn't work:
...
AnsiString s="Select rowid,... from he01201 where rowid>:ID order by
rowid";
QInfo->SQL->Text=s;
QInfo->Parameters->ParamByName("ID")->Value=StartVal;
QInfo->Open();
...
But i solved problem. I switch ADO DB-provider in TAdoConnection component
from MSDAORA.1 to MSDASQL.1
Confusion caused from situation where I had done application with VB which
do same update routine without problems and now i was converting app to
C-builder. First all seem work fine with MSDAORA.1. Test connection worked
fine and all fields seemed come through OK. Later i noticed that rowid was
missing.
"BM" <m02x7z00@cwcom.net> wrote in message news:3ba7acc9_1@dnews...
> Whats the question?
>
> "Jari Kettunen" <kettja1@www.fi> wrote in message news:3b9f2317_1@dnews...
> > I don't get Oracle RowID trough when I try it with TADOQuery.
> > Same code works fine on VB-side with same drivers.
> >
> >
> >
>
>
Technical Details
Message-ID:
<3ba844e2_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3b9f2317_1@dnews> <3ba7acc9_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,9da0c735e80996d3 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-19 00:12:22 PST From: "Jari Kettunen" <kettja1@www.fi> Newsgroups: borland.public.cppbuilder.database.ado References: <3b9f2317_1@dnews> <3ba7acc9_1@dnews> Subject: Re: Oracle RowID Date: Wed, 19 Sep 2001 10:07:12 +0300 Lines: 36 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.146.11.6 Message-ID: <3ba844e2_2@dnews> X-Trace: dnews 1000883426 212.146.11.6 (19 Sep 2001 00:10:26 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews