Devart Forums

at sqlserver:

you can write:
UniQuery.sql.text:='select 1 select 2 select 3 ';
UniQuery.open;
UniQuery.OpenNext;
UniQuery.OpenNext;


but can it write as:

UniQuery.sql.text:='select 1 select 2 select 3 ';
UniQuery.open;
for i:=2 to UniQuery.OpenCursorCount
begin
UniQuery.OpenNext;
end;


in fact ,I want to know how many DataSet in a SQL of UniQuery.Sql when it be executed.

Hello,

You can use the following code:

var
counter: integer;
begin
counter:=0;
UniQuery1.sql.Clear;
UniQuery1.sql.text:='select 1 select 2 select 3 ';
UniQuery1.Open;
repeat
inc(counter);
until not UniQuery1.OpenNext;