🚀 go-pugleaf

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
>