Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with a View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00293053
Message ID:
00293185
Views:
23
Hi Erik,

Right after I do the delete I select the view and then issue goto top and then refresh the grid. The deleted record still shows in the grid. I can't figure out what I am doing wrong?

I understand the first problem...thanks...but this second issue I can't figure out.

>>If I delete a record in a buffered updateable view and then do a tablerevert on the view the record in the base table doesn't get reverted...in other words it is still deleted. Why is this? Am I doing something wrong?
>
>If you delete a record in a view, do a TABLEUPDATE() (or move the pointer if the view is record buffered), then the deletion is written to the table. Doing a TABLEREVERT() does nothing after the changes are written.
>
>?Also If I delete a record in a view the record is still displayed in my grid even though I have set deleted on. How can I get the record in the view to not show after it is deleted?
>
>You have to move the record pointer off of the deleted record, and it will disappear from the grid.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform