How do I force database updates?
Posted on 2000-05-03
I am using Delphi 5 pro. I have a simple demonstration system for a class assignment I am giving my students that uses the DBE.
The problem is that I post records but do not see them until I exit the program and re-run it.
I have two Ttable components in a master detail relationship, tblStaff is the master, tblStaffJob is the detail.
On one form I append and post a job record using tblStaffJob. I then go to another form where I calculate the pay due to staff for the jobs they have done.
The code on this form loops through the staff records using tblStaff and for each staff record looks at all the jobs for that staff member using tblStaffJob.
The problem is that this does not find the latest tblStaffjob record unless I halt the program and start it again before running the staff pay program.
All table components are on a datamodule so the two forms use the same tblStaff and tblStaffJob Ttable components.
I would be glad of help on this - Dan