Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to update fields while deleting record in View
Message
 
 
To
04/08/2002 22:25:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00685797
Message ID:
00686373
Views:
48
This message has been marked as a message which has helped to the initial question of the thread.
>>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.
>
>Thanks, Sergey. However, is this the only way to work around it? Any tricky method to do that in one step?

The better way would be to keep audit records with key field(s) and deletion date and any other relevant info in the separate table. This will work for any backend not only VFP.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform