Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data not updating in primary table of a view
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00666382
Message ID:
00666384
Views:
20
This message has been marked as the solution to the initial question of the thread.
Hi!

Two ideas:
1. Looks like the view is already open during making the changes using DBSETPROP(). I think you have to close the view after the modification and reopen it again!
2. If the table on a which a view is based on is already open in any buffered mode then the TableUpdate of the view writes into the buffer of the table and without a tableupdate of the table's buffer the data are lost!
NOTE: Never deal with updatable views if the base table is already open in buffered mode. Ensure that the base table is opened without buffering or fire an additional tableupdate by hand!
SeBaFlu
Previous
Reply
Map
View

Click here to load this message in the networking platform