ADO recordset does not return all column values
Posted on 2006-06-16
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?