update primary key

Hi,

i need to update the primary key inside a Database Update Node.

Since the match take place from name, how can i insert the column inside the SET and WHERE clauses?

Thanks

Not sure I understand the question.  Can you post a small example using SQLITE for us to try? 

Thanks,


Aaron

one table with the column X as primary key

X
1
2

I need to update the same column:

X
3
4

Update X set X=X_new where X=X_old

With a database update i can't do this work why X_new and X_old have the same name

Hi,

the build in Database Update node does not support these kind of update statements. However you can create a sql update statement for each of your value pairs and execute it in the db by looping over all value pairs (see attached workflow).

Bye,

Tobias