• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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