🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Execute Method of TADOConnection object

#6082
From: Olov Lundin
Date: Fri, 10 Nov 2000 14:11
46 lines
2153 bytes
why not use sql

ADOQuery1->Connection  =ADOConnection1;
ADOQuery1->SQL->Add("SELECT * FROM yourtable");

ADOQuery1->Active = true;
int i = ADOQuery1->FieldByName("PK")->AsInteger;
ADOQuery1->Active = false;

Olle

Damon Warren wrote:

> Ok, I am doing this now:...
>
> TExecuteOptions *MyExeOpts = new TExecuteOptions();
> TADOQuery *ADOQuery1 = new TADOQuery(NULL);
>
> //...
>
> try {
>     ADOQuery1->Recordset = ADOConnection1->Execute(MyCmdStr, cmdText,
> *MyExeOpts);
>     int i = ADOQuery1->FieldByName("PK")->AsInteger;
> } __finally {
>     delete ADOQuery1;
>     delete MyExeOpts;
> }
>
> I am getting a stack overflow when trying to assign the Recordset property
> of the TADOQuery object to the return value of the TADOConnection Execute
> method.
>
> -Damon
>
> "Damon Warren" <damon.warren@teralogix.com> wrote in message
> news:8ueoe1$5ku15@bornews.inprise.com...
> > I am trying to use the Execute Method of TADOConnection object that
> returns
> > a type of _di_recordset... There is no documentation that I can find on a
> > _di_recordset type.... how do I access records, fields, and values in this
> > structure? is it a structure? a pointer? Thanks for any help.
> >
> > -Damon
> >
> >
Technical Details
Message-ID: <3A0C01FC.6778222@thoreb.se>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!195.22.71.206
References: <8ueoe1$5ku15@bornews.inprise.com> <8uf4fb$a234@bornews.inprise.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,358f54b6fdef4f53
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-11-10 06:11:37 PST
Message-ID: <3A0C01FC.6778222@thoreb.se>
Date: Fri, 10 Nov 2000 15:11:08 +0100
From: Olov Lundin <olov.lundin@thoreb.se>
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Execute Method of TADOConnection object
References: <8ueoe1$5ku15@bornews.inprise.com> <8uf4fb$a234@bornews.inprise.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 195.22.71.206
X-Trace: 10 Nov 2000 06:09:44 -0800, 195.22.71.206
Lines: 47
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!195.22.71.206