Getting the current value and old value in a trigger procedure 1

[Aseem1234]

Hello,

I have a stored procedure for the update on one of my tables:

PROCEDURE updCaseInfo
local x, y

IF (cst_statid) < 0
messagebox("The error will be logged!")
x = alltrim(str(oldval("cst_statid", "cases")))
y = alltrim(str(curval("cst_statid", "cases")))

insert into systemevents(se_user, se_date, se_comment) values ("Aseem", datetime(), "Status was not a valid number: changed to " + y + " from " + x)

ENDIF
endproc

When I look at the information entered in the systemevents table, the old value and new value are the same and they are both the old value. How do I get the new value entered by the user?

Thanks

 

[craigsboyd]

x = alltrim(str(cst_statid))
y = alltrim(str(curval("cst_statid", "cases")))

[sub]craig1442@mchsi.com[/sub][sup]

&quot;Whom computers would destroy, they must first drive mad.&quot; - Anon​

[/sup]

 

[Aseem1234]

That was it! Thanks a lot!