SQL syntax for record locks ?????

Hello everybody!

My application connects to a maxdb 7.5 database via odbc-driver 
isolation level = commited
I have a special table autonum where i handle automatic counters (order 
number,invoice number,...)

When inserting a new order record into the orders table the application 
does:

Select lastnumber from autonum where searchid = 'order_number'
my_new_ordernumber = lastnumber + 1
update autonum set lastnumber=?my_new_ordernumber where searchid = 
'order_number'
Insert into orders (orderno,.......) values(?my_new_orderno,......)

I don't know how to lock the selected record of the autonum tabled 
between 
selecting and updating 

The select statement above from user1 should lock the record, so that 
other users 
doing the same select have to wait (will get no new order number) until 
the update 
of user1 is finished ???!!!

I tried:

"Select lastnumber from autonum where searchid = 'order_number' WITH 
LOCK EXCLUSIVE"  with no success ??

When testing user1 select (and wait, no update)
user2 select 
User2 gets the same order_number as user1.

What is the correct syntax of the select commad, that will do the wanted 
behavior ??

Best regards
Albert


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx