I created a stored procedure to use as a trigger. It is an after
update trigger. I am getting error messages when the trigger
tries to execute. I checked it out with RSTYLE before
installing.
One message I am using a SELECT ... INTO .. FROM tablename WHERE
CURRENT OF SYS_OLD. It seems to not like my where statement.
I also have another SELECT .. INTO .. FROM tablename WHERE
CURRENT OF SYS_NEW.
I want to determine if certain fields have changed and if so
insert the values from SYS_OLD into and history table saving
previous versions of table records.
I am using version 7.6 for DOS with the lastest update.
Jim Bentley
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
