Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger for tracking changes in table
Message
 
 
To
21/06/2003 13:31:09
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00802591
Message ID:
00802606
Views:
27
>
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform