[sqlite] Get Unique Id

[Aviram]

Hi,


I'm trying to run the following SQL commands:

        CREATE TABLE T_ORDERS(OrderID INTEGER PRIMARY KEY);
        
        BEGIN TRANSACTION; 
                INSERT INTO T_ORDERS (OrderID) Values (NULL);
                Select max(OrderID) from T_ORDERS;
        COMMIT TRANSACTION;

each command in executed separately, can I be sure that the value I get from
the select max() is unique ?

Best Regards,

Aviram Gilboa

        



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]