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
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