A stored procedure is returning three recordsets via ADO.
Two of the recordsets have columns with names like
"Estimate1", "Estimate2", "Estimate3", "Estimate4", "Estimate5", and
"Estimate6".
When I run the sp via Query Analyzer, the data looks to be in the right place.
But when I run the sp from VBA and look at the recordsets, the two recordsets
with the "Estimate..." columns seem to have their values shifted.
To wit:
"Estimate1" seems to contain the value for "Estimate4", "Estimate2" seems to
contain the value for Estimate5, Estimate3 seems to contain the value for
Estimate6, and Estimate 4, 5, and 6 contain zeros.
Bottom line, in both recordsets the values seem to have shifted left 3 columns.
If I hadn't seen the right values in the right places via Query Analyzer, I'd
think it was just RCI on my part....
*Both* recordsets....and, not only that, the first recordset (no repetitive
field names though... has it's values in the proper places.
Anybody seen anything like this?
I had a previous problem where I was summing a column where one record had a
Null value and it was working A-OK via Query Analyzer, but failing miserably
under ADO/VBA.
--
PeteCresswell