Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records in a buffered view.
Message
 
To
07/11/2001 14:04:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00578650
Message ID:
00578850
Views:
22
Mark and Doru have given you good advice, but in the example you showed, you're not sending any parameters to the Tableupdate command. The default behavior for Tableupdate is to only update the current row. If you've moved the record pointer off the deleted record, and you call Tableupdate, your delete won't be written back to the source table.

>Hello,
>
>Can anyone please provide syntax that could be used to delete records through a buffered view. The buffering is set to optimistic table buffering [5] in the data environment bufferoveride property. When I run the following code from the click event of a command button it looks as though it works but when I check the underlying tables the record is still there. Also, when you delete a record I understand that it is never gone until you Pack, but with Set Deleted On should you still see the record in the underlying tables.
>***************
>***************
>Set Deleted on
>
>Delete
>
>If Tableupdate()
> Else
> Messagebox(" Delete Was Not Successful ")
>Endif
>
>Thisform.grdCustvw.Setfocus
>Thisform.grdcustvw.Refresh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform