Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Updation Of DB table from table.

Go to solution
Former Member

‎09-09-2007 5:54 AM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
former_member194669
Active Contributor

‎09-09-2007 6:01 AM

0 Kudos

Hi,

You can use update statement.

UPDATE tablename SET fieldname = value

WHERE based on the conditions.

If you are using Modify

if record doesnt exist it will be inserted on the basis of KEY

if esixts then it will be modified.on the basis of KEY

i.e. insert+update.

a®

1 REPLY 1

Go to solution
former_member194669
Active Contributor

‎09-09-2007 6:01 AM

0 Kudos

Hi,

You can use update statement.

UPDATE tablename SET fieldname = value

WHERE based on the conditions.

If you are using Modify

if record doesnt exist it will be inserted on the basis of KEY

if esixts then it will be modified.on the basis of KEY

i.e. insert+update.

a®