Re: if no lock at all for update

2005-05-15 Thread mfatene
Hi, What will happen is that the rdbms will lock the row for you, updates it and unlock it. This is transparent for the user. there will be a wait (not a problem) if another user want to update the same row. When the first transaction is committed, the second can hold a lock for update. There is

if no lock at all for update

2005-05-15 Thread Pengz9
Hi! If there is no any lock at all while one update a row, what it is going to happen to my SQL database? In which cases, it might cause problems? Anyone know? Thanks __ Switch to Netscape Internet Service. As low as $9.95 a mont