Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to update fields while deleting record in View
Message
 
 
To
02/08/2002 23:12:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00685797
Message ID:
00685900
Views:
36
This message has been marked as a message which has helped to the initial question of the thread.
>Hi, all
>I have a field designed to keep the deletion date of the record. And the table is updated through a view. Each time I delete a record, the deletion date is replaced.
>However, I found that the deletion date is only changed in the view, and it is not updated to the table. The deletion status has been triggered, though. The deletion date field is set to be updatable in view designer, that is for sure.
>Any idea about this?
>TIA

Are you trying to update and delete the same record? If so you have to do that in two steps, first update and then delete.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform