Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter Update Puzzle
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01347900
Message ID:
01347967
Views:
18
>Thanks. I did confirm that AllowUpdates is set to true, and the form automatically issues a CursorRefresh() after I issue a TableUpdate() on the cursor.
>
>Since my inital post, I've confirmed that the TableUpdate is successful by looking at the base table afterwards and seeing the change. The problem is that when I issue a CursorRefresh() on the cursor after the TableUpdate to the base table, the field value in the cursor reverts to the old value. If I close the screen and reopen it, the cursor shows the new value.
>
>Any other ideas?
>
>Thanks,
>

Are you doing your updates inside transaction? Could it also be some delay between actual update on the table (is it on the network)? Did you try to use FLUSH FORCE command (though not sure exactly how to apply in this context)?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform