RS1 RS2 ------ ---- Field1 Field1 Field2 ProcDate Country AmountI need Country added to Recordset 2. A simple idea I had is to add spaces as a new field in the query that creates RS2: ..., ' ' AS Country from xxx ...
RS1.Fields("Country").Value = RS1.Fields("Country").ValueIt does not matter what I put into the field, it always fails on the left side of the equation. The error does not specify anything more. I suspect it is a ReadOnly error but I opened the connection with adReadWrite and I tried all types of adLock parameters.
RS1.Fields("Country").Value = 1
The error changes to a type mismatch, as it should. If not, just says "Errors found". So much for descriptive error messages.
Any ideas? Or any better method to acomplish this?
Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry