>I'm curious to know...were you doing a tableupdate() after your UPDATE and INSERT statements? I would think so, or else those wouldn't work either.
>
Nope. I am not doing a tableupdate() after the Insert. Just tested it. However, the Update does not work now. Do I have to add the tableupdate() code after the Update statement?
>In order to delete a record, it is not required that you have the table buffered. But SINCE you were buffering the table (with a mode of 5), you had to do a tableupdate() to write the change (a delete, in this case) to disk.
Is any other way of bufferring preferred?
>Another option is to use an updateable view, and an updateable view is buffered. You can then bind the view's fields to the controls on your form. When using views, tableupdate() is used to send the changes back to the table.
I always thought of the cursor as a view - so much for my VFP knowledge!
>
>Do you have either
1000 Things or
Effective Techniques from Hentzenwerke? Both books have discussions on buffering and on views that you should find very informative.
I will get them.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons