>>Does GetAutoincValue() work ok with Transactions? My program does the following:
>>
>>

BEGIN TRANSACTION
>>Create an invoice header record
>>InvoiceKey = GetAutoincValue()
>>Create a set of invoice line records that include the Invoice Key from above.
>>If all ok
>>  END TRANSACTION
>>else
>>  ROLLBACK
>>endif

>>
>>Is there any problem here if a rollback is done? How does this affect any other users in the system running the same code at the same time?
>
>- The first user which insert a record lock the header table.
>- The first user which update a record lock the updated record
>- Regardless the END or ROOLBACK action the Autoinc value it is consumed

Thanks, I thought it would be ok but I wanted to check before I did it.