468,747 Members | 1,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,747 developers. It's quick & easy.

ADO Recordset: Fields Shifted?

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
Nov 12 '05 #1
1 1802
RE/
Bottom line,


..mea culpa...

Logic/data problem....
--
PeteCresswell
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Rob Meade | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.