By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

ADO Recordset: Fields Shifted?

P: n/a
A stored procedure is returning three recordsets via ADO.

Two of the recordsets have columns with names like
"Estimate1", "Estimate2", "Estimate3", "Estimate4", "Estimate5", and
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Bottom line,

..mea culpa...

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

This discussion thread is closed

Replies have been disabled for this discussion.