>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