Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Aleksey,
Thanks for the information!
KM
>>Records in the backend may be deleted by other users while a cursor is being edited. After changes made to rows of a cursor are sent back to the SQL server via a TableUpdate, we need to check afterward if the expected update has taken place in the backend. I know tricks can be done to get the information. However, it will be handy if we can check a property of the CursorAdapter to see how the backend has been updated (i.e., the number of rows updated).
>>
>
>Hi KM,
>
>If all you want is to detect an Update conflict then CursorAdapter can do it for you, check ConflictCheckType property (available in VFP8 SP1). For all other scenarios, simply execute command passed as a parameter in Before... event, get the record count, set the parameter to an empty string.
>
>Thanks,
>Aleksey.
Précédent
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