LOCKING ISSUE

[svagelis]

I have one table that contains 3 columns (ID,Index,Desc)
I use this table to collect Index and Desc in order to
make a primary key to another table.After i collect index and desc , i increase the value of Index by one.
What i want is to ensure that while i m reading Index , inserting record to another table and increase index , no other user will read index and got the same value as i got.
Is there a way to prevent others from reading index while i m doing this job?
Thanks!!

 

[balves]

You want to put a BEGIN TRANSACTION and a COMMIT TRANSACTION around your SQL code that updates one table, then takes the value from there and updates another table. And a ROLLBACK TRANSACTION on an error condition. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer