Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What does SQLEXEC() return after an UPDATE... command?
Message
De
18/10/2004 13:34:30
 
 
À
18/10/2004 10:30:52
Km Kwun
Eastop Consultants Limited
Nt, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00951936
Message ID:
00952353
Vues:
8
>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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform