By Rhys Daniell

Summary: The easiest way of generating primary key values is to use Clarion's autoincrement feature. But when multiple users access the same table/form simultaneously, this can cause problems. Rhys Daniell shows how to take control of primary IDs in MS SQL using a specialized table, two stored procedures, and some Clarion code.

Please log on to read this subscriber-only article. If you do not have a subscription you can purchase one in the ClarionMag store.