Let VFP generate T-SQL code for you. Build VFP applicatin to create the T-SQL scripts for audit (update) triggers, then run generated scripts on the server using SPT, SQL-DMO or QA. This way you'll have better performance because each trigger is tailored for specific table and easy maintanance because you can change trigger template in VFP application and regenerate and reload audit triggers for all tables. If table structure changes, you regenerate and reload audit trigger for that table only.
You can aslo consider using commercial product SQLAudit from
http://www.redmatrix.com/default.asp?section=sqlaudit>Hi, all...
>
>In my UPDATE trigger, I'd like to be able to write every DB change to an application log.
>
>I know that in my UPDATE trigger, I can do a...
>
< snip >
>
>Obviously, typing code to check for each field 'works', but I have to believe there's a more elegant way.
>
>Any ideas?
>
>Thanks,
>Kevin
--sb--