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:
00686366
Views:
40
This message has been marked as a message which has helped to the initial question of the thread.
You will probably have to make it happen in two stages. First you would set the deletion date field and commit it, then do the delete.

>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
Cy Welch
Senior Programmer/Analyst
MetSYS Inc
Previous
Reply
Map
View

Click here to load this message in the networking platform