Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>You've just got to the point where it got complicated, see above. You now have just a way to detect that the serverside record has changed meanwhile, nothing else. The server will not tell you which fields are different. I'd like to have a db server which would, but AFAIK they don't.
for that the server would need to save each record retrieved... but you could implement a history of changes
via timestamp / record change counter from other post ;-))
>To know what changed, you'd need to retrieve the current version of the record (into a separate cursor), then compare field by field with your current record etc etc, as described in that long paragraph with ouches and parentheses above. Life is tough.
Nawww, general routine to compare all the fields plus option to show all or only changed fields
with 4 columns for fieldname, transform(newval), transform(oldval()), transform(serverval())
Précédent
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