General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
PMFJI, you should need to do a delete on the view only. Only make sure that the "Send SQL update" option is checked in the view designer.
What Barbara was trying to tell you is that if your table is buffered, you will need a second TableUpdate() on the table to get the deletion all the way down to the table level.
HTH
>I am first deleting records out of the views(temporary cursors), then I am deleting the records out of the permanant table that holds the 1 to many relationship. I know that the records should be deleted with just the "delete for" clause and the table update should not be needed. I have tried deleting the records both with and without the table update and neither method works for the permanent table. Is there any way to force the data to be deleted out of the permanant table?
Previous
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