🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Use of ADO Recordset

#804
From: Viatcheslav V. Vassiliev
Date: Wed, 04 May 2005 10:04
46 lines
2565 bytes
Use recordset Fields collection, it has operator [] or GetItem() method. 
ADODataSet has property Recordset that you can use, it takes 
System::DelphiInterface< _Recordset >.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Bas Groeneveld" <nospam@nospam.com.au> �������/�������� � �������� 
���������: news:42787b1f$1@newsgroups.borland.com...
> Hi
>
> I am having trouble using a pointer to an ADO Recordset15 object returned
> from a COM control.
>
> I can access the RecordCount variable with no problems, however I cannot
> work out how to get to the actual field values.
>
> Ideally I would like to assign the Recordset to a standard ADODataSet 
> object
> and take it from there. Is there a way to do this?
>
> Otherwise what is the syntax to access the Recordset's field collection 
> and
> get to the field values. I was able to do this in C#.NET using:
>    rs.Fields["FieldName"].Value.ToString();
>
> I suspect that it is pretty straight forward. Is there a good reference to
> this somewhere - the MSDN CD doesn't seem to help much.
>
> Thanks
> Bas
> -- 
>
> ==========================================
> Bas Groeneveld
> Benchmark Design System and Software Engineering
> PO Box 165N, Ballarat North, VIC 3350
> Phone: +61 3 5333 5441  Mob: 0409 954 501
>
>
> 
Technical Details
Message-ID: <42789e2f$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <42787b1f$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,6b79b4524634c0b2
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <42787b1f$1@newsgroups.borland.com>
Subject: Re: Use of ADO Recordset
Date: Wed, 4 May 2005 14:04:30 +0400
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 85.93.138.132
Message-ID: <42789e2f$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1115201071 85.93.138.132 (4 May 2005 03:04:31 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail