SQLRegionIDSQLLastUpdatedSQLIPAddressSQLEmployeeID
I do not use these fields in the form I have created. The trigger code follows:
CREATE TRIGGER trgInsUpdOffClass ON dbo.OffClass FOR INSERT, UPDATEASUPDATE OffClassSET SQLLastUpdated = GetDate(),SQLEmployeeID = dbo.fnGetContextLogin(),SQLIPAddress = dbo.fnGetMACAddress()FROM Inserted iWHERE i.SQLGUID = OffClass.SQLGUID
The SQLLastUpdated column is causing the collision.
Ideas?
Ben
FYI - I've just posted the following in the enhancements request forum: Removing fields from the Data Collision form.
Cheers, Peter