🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Oracle RowID

#4855
From: Jari Kettunen
Date: Wed, 19 Sep 2001 07:07
34 lines
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!dnews
References: <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