Subject | IB_Transaction.DatasetCount |
---|---|
Author | Alan McDonald |
Post date | 2005-10-19T06:05:10Z |
I can use this sort of code on FormClose:
for i:=0 to IB_Transaction1.DatasetCount-1 do begin
with IB_Transaction1.Datasets[i] do begin
if State in[dssEdit, dssInsert] then begin
Post;
end;
Close;
end;
end;
IB_Transaction1.Commit;
IB_Transaction1.Close;
I get the result the code depicts.
But on FormCreate I cannot use similar code e.g.
for i:=0 to IB_Transaction1.DatasetCount-1 do begin
with IB_Transaction1.Datasets[i] do begin
Open;
end;
end;
Since IBO is creating 3 queries for every live dataset, these other (IBO
datasets) can't be opend like this.
How do I tell which ones of the DatasetCount list of datasaets are actually
the ones I have created and set up via components, and not ones IBO wants to
create at runtime?
thanks
Alan
for i:=0 to IB_Transaction1.DatasetCount-1 do begin
with IB_Transaction1.Datasets[i] do begin
if State in[dssEdit, dssInsert] then begin
Post;
end;
Close;
end;
end;
IB_Transaction1.Commit;
IB_Transaction1.Close;
I get the result the code depicts.
But on FormCreate I cannot use similar code e.g.
for i:=0 to IB_Transaction1.DatasetCount-1 do begin
with IB_Transaction1.Datasets[i] do begin
Open;
end;
end;
Since IBO is creating 3 queries for every live dataset, these other (IBO
datasets) can't be opend like this.
How do I tell which ones of the DatasetCount list of datasaets are actually
the ones I have created and set up via components, and not ones IBO wants to
create at runtime?
thanks
Alan