471,343 Members | 1,166 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,343 software developers and data experts.

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
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
1 1896
Bottom line,

..mea culpa...

Logic/data problem....
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.