Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
8 subscribers
Views
1270 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I understand that using the query database node is the only way to writ
garym
over 8 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.
OriginalPostID-177572
OriginalPostID-177572
Discussion posts and replies are publicly visible
Parents
0
narasimhaadityac
A Score Level 2
over 8 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 8 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