Article View: borland.public.cppbuilder.database.ado
Article #6082Re: Execute Method of TADOConnection object
From: Olov Lundin
Date: Fri, 10 Nov 2000 14:11
Date: Fri, 10 Nov 2000 14:11
46 lines
2153 bytes
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.206References:
<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