Hi, I understand that using the query database node is the only way to writ

garym over 9 years ago

Hi,
I understand that using the query database node is the only way to write to a table with composite keys. However, it looks like you can have a SQL insert statement but can't reference any process variables in the statement so you can perform an insert with dynamic values.
Basically, I'm trying to use the query database node to write to a table with composite primary keys but using data from process variables. Has anyone been able to do this?

Thanks.

Discussion posts and replies are publicly visible

Parents

0 narasimhaadityac
A Score Level 2
over 9 years ago

you can achieve this using the activity class parameters. if your insert statement is like "insert into table(col1, col2) values (ac!param1, ac!param2)"
then when you click on the data tab --> input you would be able to see ~1.param1, ~1.param2.. set the correct data type and the value.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 9 years ago

you can achieve this using the activity class parameters. if your insert statement is like "insert into table(col1, col2) values (ac!param1, ac!param2)"
then when you click on the data tab --> input you would be able to see ~1.param1, ~1.param2.. set the correct data type and the value.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data