>>In our order entry application, when an order is created, the next available order number is taken from a field in a table. Then, the field is incremented by 1 for the next time this routine is called.
>>
>>We want to use a SQL Server table within our .Net application to manage the next number field. However, how can we lock the table in our routine, while it's getting and incrementing the field, so that no other user can access the table. Then unlock the table when done.
>>
>>We want to avoid two or more users getting the same next number order number from the table's field.
>>
>>How can this be done?
>>
>>Thanks,
>>
>>Jerry
>
>How about using an autoincrementing field? Another thought is to use the uniqueidentifier field type.


Thanks, good point. Yes, I can make the order number field in the order header table an autoincrement. I was trying to duplicate what we currently do with VFP without an autoincrement, but you make a good point.

Thanks,

Jerry