>What is the most efficient way of handling this?
>Assuming I have a compound PKEY or CANDIDATE
>should I do a SEEK before modifying a one of
>the components or is it more efficient to trap
>for the error?
>
> ...kt
Really IMHO the proper way to do this is to generate the primary key yourself, and make sure its unique when generated. This means either use a table to keep track of keys generated for each table, or come up with a key routine that will always give you a unique value, something along the lines of SYS(0)+SYS(2015) which should pretty much guarantee a unique value.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc