updatecommand need to get previous value

[Allen]

I'm using batch edit and auto operation in my grid.  I need to get the previous values of the cells for the update command.
My update command is as follow:
UpdateCommand="BEGIN UPDATE "WFM_CAT_RECURRENCE_DT" SET "FROM_YEAR" = :FROM_YEAR, "FROM_WEEK" = :FROM_WEEK, "TO_YEAR" = :TO_YEAR, "TO_WEEK" = :TO_WEEK, "USERID" = :currUserID, "USERNAME" = :currUserName, "CREATE_DATE" = SYSDATE WHERE "DIVISION" = :DIVISION AND "DISTRICT" = :DISTRICT AND "LOCATION" = :LOCATION AND
"FROM_YEAR" = PREVIOUS_FROM_YEAR AND "FROM_WEEK" = PREVIOUS_FROM_WEEK AND "TO_YEAR" = PREVIOUS_TO_YEAR  AND "TO_WEEK" = PREVIOUS_TO_WEEK  
"USERID" = :USERID AND "USERNAME" = :USERNAME AND "CREATE_DATE" = :CREATE_DATE; exception when dup_val_on_index then null; End;">

I need to pass the previous cell value to PREVIOUS_FROM_YEAR,  PREVIOUS_FROM_WEEK,  PREVIOUS_TO_YEAR, PREVIOUS_TO_WEEK.  Can anyone tell me how to accomplish this?

[Angel Petrov]

Hi Allen,

In order to obtain the old values you can subscribe to the OnItemCommand or OnBatchEditCommand events and extract them from the arguments as demonstrated here.

Regards,
Angel Petrov
Telerik