Problem commiting change to server when closing file

[admin]

@hugo

Adding a save statement before closefile fixes the problem, however this solution doesn’t work if the shared file is secret using setactivedatabase … as the save statement changes the focus back to TestA

I didn’t quite read your post carefully enough yesterday, and missed this key point. On further researching this, I realized that the save statement is required to make sure that the data gets saved locally. This also unlocks the record.

However, as you pointed out, when you use save with a “secret” database the window changes. There are two solutions to this:

opensecret "TestB"
setactivedatabase "TestB"
FieldA=today()
save
setactivedatabase "TestB"
closefile

Or:

opensecret "TestB"
setactivedatabase "TestB"
FieldA=today()
save
closedatabase "TestB"

I’ve tested both of these approaches and they appear to work correctly with the b29 release. The unlockrecord statement isn’t needed (the save statement unlocks automatically). I’ve changed closefile and closedatabase so that they also unlock automatically, but the save statement is still needed.