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-11-07 : 09:09:29
|
| Byron writes "Here is my queryselect f1,(select count(*) from table2) as f2,(select max(somefield)from table3) as f3 from table1;okay...here is the problem....when I move through the recordset, I want to update the f1 fields datawith the f2 fields data ...do while not rs.eof rs("f1")=rs("f2") rs.updaters.movenextloopI get the following error....Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'f2'." |
|
|
|
|
|
Update Field Problem.....