Article View: borland.public.cppbuilder.database.ado
Article #804Re: Use of ADO Recordset
From: Viatcheslav V. Vassiliev
Date: Wed, 04 May 2005 10:04
Date: Wed, 04 May 2005 10:04
46 lines
2565 bytes
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-mailReferences:
<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