John Christenhusz asked on the DUG_DB list (how did he post
there - it seems to be defunct?)
G'day folks,
This is paradox question. When I modify a record from a table and post it, the physical table has not been updated yet. I assume the DBE keeps it in memory till the application is shut down or that there is enough changed data worth starting the actual save procedure. 1. Is this assumption correct ? 2. How can this be solved so that the physical table is updated when I want it to be available for other external purposes? (note that an close table - open table doesn't seem to work). 3. Is there any way to detect if the physical table is not updated yet? TIA John. My (bounced) response was:
John
I'm sure you will get a more complete answer from someone else, but in the meantime: In my code I have used DBISaveChanges(Handle); immediately after each Post. although I discovered later that a much better way is to put that code into the TTable's After Post event. My understanding is that doing the above will update the database files on disk but it will still not notify other users that the table has been updated - that is another whole question (which is way beyond me at this stage) Hope this is of some use. Mark |
BEGIN:VCARD VERSION:2.1 N:Howard;Mark FN:Mark Howard EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010705T213131Z END:VCARD