Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aiby
Yak Posting Veteran
71 Posts |
 Posted - 2003-09-24 : 01:35:37
|
| How can I lock a field in a table?Problem: In Client/Server Data base design environment, i have to lock a particular rows, specific column only!Eg:- One Row-field of a count control table A multi company, multi user sales management system - in each company they have different sales counters, reciepts and payment counters. In such situations i have to generate unique Bill Numbers, Reciept/Payment voucher number etc. from a Count control table which countain multiple rows and Company ID as the primary ID. Here each column in every row will be accessed by multiple users. What will be the optimised locking solution for the problem? I would like to get a solution for lock a particular column of a paricular row?Aiby Mohan DasSystem AnalystOviaym info solutions & Technologies P.Ltd.Kerala, IndiaEmail: info@oviyam.com |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-24 : 01:38:48
|
How can I lock cross posts because they are rude ?Oh hey, I can  Damian |
 |
|
|
|
|
|
How can I lock a field in a table?