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
5 replies
Subscribers
7 subscribers
Views
2093 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have a CDT and need to update its values to DB frequently. How do I update onc
nitas811
over 11 years ago
I have a CDT and need to update its values to DB frequently. How do I update once the DB has the CDT values. In case the values are there I just want to update and not insert new rows everytime. How would I do that? ...
OriginalPostID-98131
OriginalPostID-98131
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 11 years ago
This may not be an elegant solution but you can create another column in your table that stores the composite key as a single column value. You can use this to Map to the cdt. The challenge here is that it pushes the onus of creating and managing the pk to the developer instead of database. Apart from that, the general recommended solution is to maintain a single p.k
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 11 years ago
This may not be an elegant solution but you can create another column in your table that stores the composite key as a single column value. You can use this to Map to the cdt. The challenge here is that it pushes the onus of creating and managing the pk to the developer instead of database. Apart from that, the general recommended solution is to maintain a single p.k
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data