Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger for tracking changes in table
Message
 
 
À
21/06/2003 13:31:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00802591
Message ID:
00802606
Vues:
28
>
>llOK=.oCodZonas.SAVE(.oRS0)
>Layer
>case toRS.LockType = adLockBatchOptimistic
>    .oConnection.BeginTrans()
>       toRS.ActiveConnection = .oConnection
>	toRS.UpdateBatch()
>	if .lErrorOccurred
>          .oConnection.RollbackTrans()
>	  toRS.CancelBatch()
>        else
>	 .oConnection.CommitTrans()
>       endif .lErrorOccurred
>     toRS.ActiveConnection = .NULL.
>
Joao,

The code you posted can update any # of records. To test your triggers, run UPDATE/INSERT/DELETE command from Query Analyzer (QA). Otherwise you wouldn't know if trigger isn't working correctly or frontend sends incorrect or unexpected commands.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform