Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger for tracking changes in table
Message
From
21/06/2003 13:31:09
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00802591
Message ID:
00802602
Views:
27
>I was asking about command that updates record and causes trigger to fire.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform