>ValidateField()
>
>instead of
>
>ValidateField('table.field')
>
>In the function I can do something like:
>
>cRuleTable = somefunction() && alias() maybe???
>
>cRuleField = somefunction() &&no idea here...
You can count on ALIAS() always returning the correct _alias_ when used from a stored procedure called from a trigger, but there is not way to detect the field. Stored procedures are just procedures loaded when the database is opened, there is nothing else magic or special about them- they are tied to the field only by the field... there is no other record of correlation.
Erik Moore
Clientelligence