Quote:

---

Originally Posted by pelegk1
i have made a select on a table
"select * from tblData"

and i want when i go over the fields that :
if rs("field1")="1" then
update field2=1 ' *
end if

how do i do (*)?
thnaks in advance
peleg

---

Quote:

---

Originally Posted by pelegk1
i am going over every line in the record set
i check 1 of the fields of that line
and in some condition if a feld called "field1" =1
then i want in the same line to update the value of field2 to 1!
and of course that this will be updates at the sql server

---

Quote:

---

Originally Posted by pelegk1
each row and read its values!


and no just to write "update field2=1" never will work!!"

---

Do while rs.EOF=False
'Put it your update code
'Instead of this, Why can't you use SQL commands. 
For Database operations (Insert. Update, Delete * Select) 
SQL is the only one best method and efficient method

rs.MoveNext
loop

Quote:

---

Originally Posted by pelegk1
[this is in visual basic 6]

strSql = "select * from db1 where file1='0'"

Set rsecordSet = GetRecordSet(strSql)
While Not rsecordSet.EOF
field1= rsecordSet.Fields("field1")
x= rsecordSet.Fields("x")
y= rsecordSet.Fields("y")
z= rsecordSet.Fields("z")

rstA72RecordSet.Open "update A72 SET [FL00004] = 1 where (num=" & rstA72RecordSet.Fields("NUM") & ")"

rstA72RecordSet.MoveNext
Wend

---

Quote:

---

Originally Posted by pelegk1
strSql = "select * from db1 where file1='0'"

Set rsecordSet = GetRecordSet(strSql)
While Not rsecordSet.EOF
field1= rsecordSet.Fields("field1")
x= rsecordSet.Fields("x")
y= rsecordSet.Fields("y")
z= rsecordSet.Fields("z")

rsecordSet.Open "update A72 SET [FL00004] = 1 where (num=" & rstA72RecordSet.Fields("NUM") & ")"

rsecordSet.MoveNext
Wend


so whats next?

---