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 |
|
mansoor1
Starting Member
2 Posts |
 Posted - 2006-06-08 : 08:51:17
|
| Hi Guys,When i use to loop through one table in my database having more than 100,000 records, it disturbs values in a different table. I am using Visual Basic 6 Frontend and SQL Server 2000 Enterprise EditionCan you please tell me whats going on.Thanks,MA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-08 : 09:52:41
|
| What do you mean disturbs?Are you updating? Is there a trigger on the table?==========================================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. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-08 : 10:12:37
|
| Are you using Cursor to loop through the table?MadhivananFailing to plan is Planning to fail |
|
|
|
mansoor1
Starting Member
2 Posts |
Posted - 2006-06-10 : 09:03:43
|
| no, i am using microsoft visual basic 6.0. and usingconnection.execute method to loop through the database and update some columns like col1=primary keymSaveStr="Update table1 set col1=3,col2=4 where col1=1"connection.execute(mSaveStr) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-10 : 09:06:29
|
| The above statement will update only one row as col1 is primary key. What is the difficulty in that? Give us more detailsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL Server 2000 Reconsilation Problem