General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only