problem on TOracleDataSet.active property

[alain]

ING from Paris

Dear Mr Kalter

I need to retrieve datas from a detail TOracledataSet after modifying datas inside
(insert or delete or scrolling of the master)
that's why i tried to make it in several type of events like:
it's AfterQuery event
or
in the AfterQuery of it's master TOracledataSet
but in these events sometimes it's "active" property is true and in my case the most of time is false and i can't iterate in it (because it's closed) with a structure like :
while not MyComponent.EOF do
begin
........Instructions..
MyComponent.next
end;

Is it a bug? and in all cases
could you help me please.

Thanks by advance
ING Paris

------------------

 

[Marco Kalter]

The correct event to use is probably the AfterScroll event of the master dataset. You still need to check if the detail dataset is active, but when the AfterScroll event fires, the details will have been queried.

------------------
Marco Kalter
Allround Automations