🚀 go-pugleaf

It is true for ADO recordset object, not only for ADO Express. ADO Command
object Execute method returns Recordset object, so you may be can do:

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

Client-side cursor fetchs all rows from query (table) into memory, so you
should decide do you need advanced features (such as record count, filter,
sort) with client-side cursor or faster code with server-side cursor
(sometimes client-side cursor can be faster).

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Tom Jowitt" <tomjowitt@hotmail.com> ???????/???????? ? ???????? ?????????:
news:3e6f2390@newsgroups.borland.com...
> thanks but i am not using ADOExpress as i have BCB5 Pro edition and
> hence cannot use ADOExpress without a significant upgrade.
>
> the add-on i use uses TADORecordset
>
> i got it working by changing the cursor type like you said. thanks!
>
> Viatcheslav V. Vassiliev wrote:
> > It is normal if you are with server-side cursor. If OLEDB provider can
not
> > return affected rows quickly, it can return -1. Recordset (there is not
> > TADORecordset object in ADO Express) is returned by TADOCommand.Execute
> > method.
> >
> > This is a sample from help:
> >
> > with ADOCommand1 do begin
> >   CommandText := 'SELECT Company, State ' +
> >     'FROM customer ' +
> >     'WHERE State = :StateParam';
> >   CommandType := cmdText;
> >   Parameters.ParamByName('StateParam').Value := 'HI';
> >   ADODataSet1.Recordset := Execute;
> > end;
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > and Interbase (through OLEDB) databases.
> >
> > "Tom Jowitt" <tomjowitt@hotmail.com> ???????/???????? ? ????????
?????????:
> > news:3e6f0910$1@newsgroups.borland.com...
> >
> >>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
> >>
> >
> >
> >
>