Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete a record based on a cursor
Message
From
25/06/2002 17:58:17
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
25/06/2002 17:42:36
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00672147
Message ID:
00672227
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform