Thanks you, Jhaith....
this is a new lesson for me..
I solved the locking problem. i created a index with pagelocking option with batchid. now it is working
Thanks
Rigards
thanks for your replay
There are some code within the loop i omitted...
My problem is about locking. why all the records get locked once a single row is updated(when i=1). row level locking is not happing here...
thanks
Thanks for your reply
This is a POS Program where BATCH Table is holding the available stock. All users are reading the batch table
Continuously for knowing available stock, and updating the stock after each sale is made. the batch table holding many product's stock. and in one sale there will...
HI
please help me to change sql server locking option to TABLE LOCK to PAGE/ROW LOCK
I AM USING .NET + SQL SEVER 2005 EXPRESS
I tried like this :-
cmd.Connection = Conn
trn= Conn.BeginTransaction()
cmd.Transaction = trn
For i=1 to NumOfProd
cmd.CommandText = "Update batch set stock="...
HI
please help me to change sql server locking option to TABLE LOCK to PAGE/ROW LOCK
I tried like this :-
cmd.Connection = Conn
trn= Conn.BeginTransaction()
cmd.Transaction = trn
For i=1 to NumOfProd
cmd.CommandText = "Update batch set stock=" & vqty & " where batchid=" & vid...
HI
i am trying to read sql server records exclusive...
but it is not working (sql server 2005 and vb.net)
this is my code
dim cmd As New OleDb.OleDbCommand
cmd.Connection = Conn
cmd.CommandText = "select batch.Stock from Batch WITH (XLOCK) order by BatchId"
dim dataredr As...
hi
in my vb program, i am Creating/Copying the files.
But some times the new created files are missing or
Corrupt after rebooting the server its creates found.001/002... in c drive of the server.
OS is WinXp and 6 pcs are in the network,
i tried with formating the pcs but same problem...
hai
My 15mb .mdb file having last-modified-date
'Wednesday, November 22, 2006, 9:28:09 PM.'
After copying the same file to another Pc through network the last-modified-date is changed to
Wednesday, November 22, 2006, 9:28:11 PM.
only 2 seconds difference
this gives problems in my backup...
Hi friends,
Please help me in using MSCOMM control for sending & receiving binary files along with file name.
In my Programm, user will select the file-name and send the file, The receiving computer will save the file in the same name.
my problem is this, When i am sending the file in single...
Hi
I want to develop a smart device program for order booking.
My customer is having 'Nokia Communicator 9210i' Device.
With Symbian OS.
Please help me in following problems
1. Is Nokia Communicator 9210 is a programmable device?
2. Is it possible to run VB.net program in it ?
3. What...
hi
I am a VB6 application developer. now i got a chance to develop a simple Web site for an company.
Web site is for searching a product from a database
and display the details of it.
i would like to know which is th best language to develop a web-page. which databate is better and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.