tableupdate (not really a question but more of an answer)

[friend01]

Hi All,

I just wanted to let you guys know of the answer to some 'random' problems that I have been having lately.

Problem: Users would make changes to the .dbf thru my app and sometimes the changes ("the replaces") would take effect and sometimes they wouldn't. It was really really weird becuase it was really sporadic. Nonetheless, I came to the realization that it was the darn 'tableupdate' command which I had totally forgotten. The problem was breaking my head for weeks (becuase, as I mentionned, it was really sporadic) and in IMHO, those are the worst problems to figure out.

So, in conclusion, a lesson learned. If you see that your 'replaces' are working or not working for that matter, or a re working only some of the time, please check if you did a 'tableupdate'! Very important!!

Again, thanks to all/everybody for their help.

I just thought I'd share that with you and have a great weekend everybody.

Again, thanks!

F1

 

[Olaf Doschke]

Hello friend,

yes, it's true that you can do any replaces, also updates, inserts, deletes, any operations on a table. As long as it's buffered the changes won't be applied to the DBF file, unless a tableupdate() is sending changes.

But that's not the end, you also will need to check the success of the tableupdate. If it returns .F., AERRORS() will create an array helping you find out what conflict prevented the tableupdate to work.

Bye, Olaf.