Execute Method of TADOConnection object

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Damon Warren Thu, 09 Nov 2000 17:41

#6071

Author: Damon Warren
Date: Thu, 09 Nov 2000 17:41

6 lines
1153 bytes

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

Re: Execute Method of TADOConnection object

#6074

Author: Damon Warren
Date: Thu, 09 Nov 2000 21:15

33 lines
1834 bytes

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
>
>

Re: Execute Method of TADOConnection object

#6082

Author: 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
> >
> >

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads