>I need to get the next available record number from my table. Ussing a 'BEGIN TRANSACTION' and only 'END TRANSACTION' at end. Multilple inserts will take place and for every insert I need to know the record number(auto increment column in my table) to add records to a detail table (link on the record number of the header table).
>
>Must perform the same function as the @@identity in a MS SQL server database.

Use the field value, after the insert command.

begin tran

INSERT ...MYTABLE...
INSERT INTO DETAIL (idTable...) value (MYTABLE.autoincfield,...)

end tran