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 - 2001-03-23 : 16:53:45
|
M8_FreeStyler writes "i have a table with some identical rows, the following code:
rsrecordset.open "select* from table1 order by partnumber, orderentry"
returns for example:
part 1 4 4 12345
part 1 4 4 12345
part 2 3 2 52412
when i call the method
rsrecordset.movenext
rsrecordset("field1") = 5
rsrecordset.update
it crashes saying that it cannot find the row to update at the identical rows. The identical rows are normal, for example, a customer can order 4 of part 1 in the morning, and 4 of part 1 again in the afternoon.
Is there anyone that can help me in resolving this issue? are there anyways around this...i have been stuck for days....." |
|
|
|
|
|
updating two identical rows