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?


Who is Participating?
Ephraim WangoyaConnect With a Mentor Commented:

Sorry I'm not familiar with sqlDirect components, but the principle should be the same

If you are adding data directly to the dataset, there is no reason the data should not be displayed as you type it in otherwise how do you know what you are typing in.
Unless you are adding data to a temporary dataset or object and a different function adds the records to the dataset before calling ApplyUpdates

I would very much like to see the code for this if you can post it here
Ephraim WangoyaCommented:

To check if records have changed
Dataset.ChangeCount > 0

To get a fields new value

To get the fields old value
TheMatrixDuckAuthor Commented:
Thanks for  your answer.  I have tried Dataset.Recordcount after inserting 3 records.  The count always returns 0.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Ephraim WangoyaCommented:

What components are you using for your datasets


Note unidirectional datasets will not return the RecordCount nor will they allow you to use First, or Prior
TheMatrixDuckAuthor Commented:
sqlDirect data access components (TSqlQuery).
TheMatrixDuckAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.