Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records in multitable view
Message
 
 
To
31/07/2009 06:34:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01415612
Message ID:
01415617
Views:
51
What's the error ( AERROR() ) in TABLEUPDATE()?

>I have a view based on tables A,B,C. Only the fields in A are set to be updateable. I can add and edit without any problem. If I delete a record and try to update the base tables the update fails as does the subsequent Requery(). I have been hunting around on UT and have seen a suggestion that this is a known issue - but I can't identify a work-around. Can anyone help? Sample code snippet below
>
>
>delete next 1
>mytest=TABLEUPDATE(.T.)
>* mytest returns .f.
>REQUERY("v_myview")
>* Fails with cursor contains uncommitted changes
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform