ADO and NextRecordset method
Delphi 5 C/S, ADO, SqlServer 2000
I have an SP that returns 2 recordsets (sometimes). I seem to be having a
problem accessing the second recordset. Here is what I'm doing and it wont
compile.
var
I : integer;
begin
with qrySomeData do begin
open;
if recordcount = 0 then
qrySomeData.Recordset.NextRecordset(i);
........
......
......
end;
The "nextrecordset" statment wont compile. I only want to access recordset 2
if the first one is empty (recordcount=0);
What am I doing wrong.
PS .. all updates ot ado applied for D5 C/S
.
Relevant Pages
- Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: DAO to ADO Recordset Options
... DAO was really fast when dealing with Access data (faster than ADO) but was ... Recordset. ... For client-sided cursors, there is only Static cursor type regardless as ... determines how often data is fetched from the server. ...
(microsoft.public.data.ado) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) |
|
