I have created a UDT and related SQL Queries. I have individual queries that perform the following functions.
1) Insert
2) Update
3) Read
4) Delete
When I run each query individually in succession I get the desired results, but when I try to combine the queries in one statement I get a "duplicate pk error".
My questions are as follows:
Can I combine these types of queries in one statement within B1?
Can I use the 'SBO_SP_TransactionNotification' to combine these functions?
Can I create my own SP to modify a UDT?
Much thanks,
Rob