• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 720
  • Last Modified:

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!

0
TheMatrixDuck
Asked:
TheMatrixDuck
  • 3
  • 3
1 Solution
 
Ephraim WangoyaCommented:

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
0
 
TheMatrixDuckAuthor Commented:
Thanks for  your answer.  I have tried Dataset.Recordcount after inserting 3 records.  The count always returns 0.
0
 
Ephraim WangoyaCommented:

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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
TheMatrixDuckAuthor Commented:
sqlDirect data access components (TSqlQuery).
0
 
Ephraim WangoyaCommented:

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
0
 
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.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now