Oooops, my mistake ...
>>>insert into sales (customername,product,amount) values ('klm',
>>>>'pizza', 50.00)
>>>> -----generates billno = 3 >>>>>> here was the mistake wherein the
>>>> original post it was billno = 4.
what you did was absolutely right.
still what i meant was, could there be a way by which the autonumber
(autoincrement) would automatically start from billno 2, rather than
starting from billno 3 when we delete the last record where billno =
2.
I dont want to use a select statement to get max (billno) and then use
billno+1 when inserting the next record. and also i think this method
may lead to inconsistency in data when in a multiuser enviornment.
thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
