Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter Update Puzzle
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01347900
Message ID:
01347967
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform