Data Buffering & VFP

[Scott24x7]

Hi all,
It's been quite a while since I had to do any VFP development, but I've had to dust of an application I wrote a couple years back, and do some work on it. Have forgotten a very silly thing, and I remember running into this back in the day, but cant remember hot to resolve it.
The issue is, I open an existing Database, and then right click on a table, and select Modify. (They're in a DBC). When I do, I get a message stating "Command cannot be issued on a table with cursors in table buffering mode." Now, I normally have optimistic table buffering as my method of dealing with commits to data. And I set Multilocks, and Exclusive on in the "Settings", as well as Table Buffering, which I thought would allow me to do this, but I can not. What is the silly thing I am missing?
And now, even when I try to change the "Settings" back, I when I set Multilocks off, and buffering off in an attempt to get rid of it, I get a message stating "Table or row buffering requires that SET MULTILOCKS is set to ON. - Error setting MULTILOCKS.
Any help? Need to modify a table structure!


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[Olaf Doschke]

If there is anything in a buffer, you can only get rid of it by either saving it with tableupdate() or cancelling it with tablerevert().

Bye, Olaf.

 

[Scott24x7]

Olaf,
HA! Feeling stupid now. Thanks. I knew it was something simple.
-S

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."