I have 2 stored procs like
1. Select T1.A, T1.B, T2.C
From T1, T2
where 0 = 1
This returns me an empty recordset
2. select T1.A, T1.B, T3.D, T4.E
From T1, T3, T4
where (**some conditions-**)
In VB I transfer data between these recordsets based on certain criteria.
2. RecordSet1.Fields("A").Value = RecordSet2.Fields("A").Value
3. RecordSet1.Fields("B").Value = RecordSet2.Fields("B").Value
4. RecordSet1.Fields("C").Value = Some constant value.
Now my problem is with line 2 above.
This is where i get the multi-step error.
If i skip this step and move on there are no errors.
I am getting this field A in both recordsets from the same table, so there shud not be a datatype related error.
field A is primary Key on the table.
Please help me get over this issue.
Let me know if you need more information.