effect of trigger in Access?
With Access 2000 or 2003, is there a trigger or onChanged method? I
would like to be able to do a mailto if certain fields change in my db.
Thanx.
.
Relevant Pages
- Re: COLUMNS_UPDATED() with triggers
... but then I found COLUMNS_UPDATEDwhich returns a bit mask of the ... Be aware that these functions do not indicate a column value has actually changed as a result of an UPDATE statement. ... fields change, but I want to get a bit smarter and only clean a field ... Note that this is an AFTER trigger so the columns will have already been cleaned by the time the trigger fires. ...
(comp.databases.ms-sqlserver) - Re: Update Query Runs Forever
... would think it would prevent trouble down the road since, if the fields change, it automatically uses the current fields at all times. ... What kind of trouble are you referring to. ... You make the assumption that someone who will change one of the tables later on will know about this trigger and the process of archiving to another table, ... If you have concurrent users running queries on the table, a transaction that updates 200 rows may have a chance for time span to complete in between user queries. ...
(comp.databases.ms-sqlserver) - COLUMNS_UPDATED() with triggers
... I have the trigger only clean the columns only if ANY of the ... fields change, but I want to get a bit smarter and only clean a field ... City = dbo.udf_CleanAlphaNum, ...
(comp.databases.ms-sqlserver) - dynamic field names
... I have to log changes to certain fields in my table as the values of these ... fields change, but I want to make it flexible so that end users could ... table that retrieves the fields to track and if that field changed would get ... The problem is that I can not do something like this in a trigger: ...
(microsoft.public.sqlserver.programming) |
|
