Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using WhereType = 4 (timestamp) in remote views
We have a vfp front-end app with sql 2k5 backend that use remote views. For the remote views, we've been using WhereType = 3 so far without major problems. Recently we are researching about using WhereType = 4 (timestamp) mainly for performance reason, among others.
I am currently testing this for a selected tables. Added timestamp in sql table, modified an updatable remote view to include timestamp column in the select clause, WhereType to 4, etc. Ran a data-entry form in the app that update/delete/insert using this remote view, and the form seems to save fine the first time. If I make another change WITHOUT exiting the form, and click save, then I get a 'update conflict' error.
Do I need to requery each time I save to refresh the timestamp field in the view? Is there any other option that I'm missing? I'm trying to avoid an extra requery if I could.
Thanks,
Sid.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement