Lock record

From: Arnaud BALAY <arnaud_at_europrint.fr>
Date: Wed, 1 Aug 2001 10:37:44 +0200
Message-ID: <9k8f4l$1ip$1@front7m.grolier.fr>

Hi,

This is surely a commun question, but I can't get any answer. A table on my DB contains all counters. One record of this table contains the current order number. What is the correct way to use and change the current order number ?
Is this correct :
-Lock the record (How ?)
-Read the current order number
-Write the next one
-Unlock the record (How ?)
-Use the read order number to add a new order

Thanks for your help.

Arnaud Received on Wed Aug 01 2001 - 03:37:44 CDT