Hi all,
In a VB6 procedure, I have a recordset from table t1 and i want to modify some fields and insert the new value of this recordset in another table t2. t1 and t2 have the same structure.
Here is my code :
SQLquery = "select * from t1"
Set rs1 = db.OpenRecordset(SQLquery, , 3, 3)
Do Until rs1.EOF
rs1.Edit
rs1.Fields("code"
= "code1" 'code is modified
rs1.Fields("libelle"
="libelle1" 'libelle is modified
'here, I want to insert rs1 in table t2, which has the same structure as t1
rs1.MoveNext
Loop
rs1.Close
Thanks in advance for your help.
In a VB6 procedure, I have a recordset from table t1 and i want to modify some fields and insert the new value of this recordset in another table t2. t1 and t2 have the same structure.
Here is my code :
SQLquery = "select * from t1"
Set rs1 = db.OpenRecordset(SQLquery, , 3, 3)
Do Until rs1.EOF
rs1.Edit
rs1.Fields("code"
rs1.Fields("libelle"
'here, I want to insert rs1 in table t2, which has the same structure as t1
rs1.MoveNext
Loop
rs1.Close
Thanks in advance for your help.