I need to implemet a logging system on a table by table basis and thought to use the insert and update triggers. This seems to work.
in teh trigger I scatter the fileds to an array and select the logtable insert a record anr write the array into a memo field, replace the user id and datetime and that's it. It works on 8 or so tables but not on the ninth ????
has anubody tried this approach? any better ones??
Thanks
Peter
Peter Cortiel