🚀 go-pugleaf

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