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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-02 : 06:32:32
|
| Manuel writes "i have to edit a register of the table, so i use the UPDATE command, everything worked well until i tried to edit the same register, then the sql sentence makes the page display an error on line 0 (zero) which doesn't exist in the page, usually this error appears when i forgot a query key, but in this case all the query key are in order and the register just edited is correct, but it doesn't work no matter what. why this just happen when i try to modify a regiter alredy modified? Maybe is the time the database to update itself? and if is that, why it ahow the register modified whit the changes alredy updated?the i dont know what version of sql is and i'm using win 98" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-02 : 08:34:46
|
| register?The record will be locked while it completes the update and any access will wait until it is released.The sql statement will not complete until the update is complete and the record released.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Late updates?