Link to home
Start Free TrialLog in
Avatar of TheMatrixDuck
TheMatrixDuck

asked on

Where is the data stored until ApplyUpdates is called

I need to read data that has been posted to a table before ApplyUpdates is called.  Using Delphi 3 and Guptas SQLBase database.  When the data is posted, the records are not visible in the table until ApplyUpdates is called.  
Does anyone know where the cached records are stored?

Thanks!

Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image


To check if records have changed
Dataset.ChangeCount > 0

To get a fields new value
Dataset.FieldByName('yourfiled').Newvalue    

To get the fields old value
Dataset.FieldByName('yourfiled').OldValue
Avatar of TheMatrixDuck
TheMatrixDuck

ASKER

Thanks for  your answer.  I have tried Dataset.Recordcount after inserting 3 records.  The count always returns 0.

What components are you using for your datasets

ADO or BDE.

Note unidirectional datasets will not return the RecordCount nor will they allow you to use First, or Prior
sqlDirect data access components (TSqlQuery).
ASKER CERTIFIED SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I did not clarify my question accurately enough.  I was attempting to access the records from a dll where the recoredset is not visible.

If I had worded the question correctly, I'm sure I would have received a more contextually accurate answer.