Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

ADO recordset does not return all column values


Hello EE

I use stored procedure to select a record that consists of at least 40 columns and two of them are text as datatype. I noticed that when I read the recordset in VB6, some of the fields are blank but it has values in the database. If I do not include the two text columns, I get all the results I need. It appears to have some kind of limit in ADO recordset in VB6 because I get the results I need in Query Analyzer. How I get around this in VB6?

Thanks


0
lunchbyte
Asked:
lunchbyte
  • 3
  • 2
1 Solution
 
leonstrykerCommented:
You should conver the data to Varchar in your final select.

Leon
0
 
lunchbyteAuthor Commented:
What if it exceeds 8,000 characters.
0
 
leonstrykerCommented:
Then you will need to use ADO Stream object to return tht data.

Leon
0
 
lunchbyteAuthor Commented:
That was the keyword I need to do my research on. Thanks.
0
 
leonstrykerCommented:
No problem, thanks for the grade,

Leon
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now