Skip to Content
0
Former Member
Sep 09, 2007 at 04:54 AM

Updation Of DB table from table.

27 Views

Hi ,

My requirements is I need to update the DB table and during updation only two fields are to be changed based on a condition, Rest of all the fields shud remain same. I passed the fields ( that are to be changed) using the work areas( Modify <table>) . but then whn i check in DB table a new record is getting created with just two fields that were passed and old record still exists and is not updated. Could you please tell me as how to create a updated row containing the old values + the fields that are updated.

Thanks