Skip to Content
Former Member
Dec 12, 2008 at 06:01 PM

UDT Insert and Update


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,