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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-06-22 : 19:03:59
|
| With rs j = 0 Do While Not .EOF rs(0).Value = j j = j + 1 .Update .MoveNext LoopEnd WithSet rs = NothingI think the problem is my eof setting but I don't know how to adjust that in code since I am not using an adodc. If that is my problem then can I get the code snippet, please?Otherwise, what is my problem?Thanks! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-06-23 : 04:20:21
|
| My thoughts are -Can you send "UPDATE yourtable SET yourfield = yourfield + 1" and do the whole update job in one statement, instead of row by row? (or, better, call a procedure to do it.)You may need to check for rs.eof before you enter the while loop, in case it assumes at least one iteration.-------Moo. |
 |
|
|
|
|
|
Not Updating Last Record in RS