recordset populating problem

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

Article #2860

Back to borland.public.cppbuilder.database.ado Previous Next

#2860

From: Tom Jowitt
Date: Wed, 12 Mar 2003 10:16

14 lines
1500 bytes

i have problems using the TADORecordset function. i can use commands to 
execute SQL but can use the Recordsets. everytime i populate a recordset 
it brings back the recordcount as -1. this is how i execute the SQL:

ADOCommand1->Close();
ADOCommand1->CommandText = "SELECT Wellname FROM Wells";
ADOCommand1->Active=true;
ADOCommand1->Open();

ADOCommand1->Execute(RecordsAffected, EmptyParam, adCmdText);

how do i return a recordset from this command?

cheers in advance

Technical Details

Message-ID: <3e6f0910$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!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,7058e89c5142fa3b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-12 02:29:12 PST
Date: Wed, 12 Mar 2003 10:16:16 +0000
From: Tom Jowitt <tomjowitt@hotmail.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: recordset populating problem
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.30.132.201
Message-ID: <3e6f0910$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1047464208 62.30.132.201 (12 Mar 2003 02:16:48 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail