<div>
You should conver the data to Varchar in your final select.<br />
<br />
Leon
</div>


You should conver the data to Varchar in your final select.

Leon

<div>
What if it exceeds 8,000 characters.
</div>


<div>
That was the keyword I need to do my research on. Thanks. 
</div>


That was the keyword I need to do my research on. Thanks.

<div>
No problem, thanks for the grade,<br />
<br />
Leon
</div>


<div>
<div class="content wysiwyg-content">
<br />
Hello EE<br />
<br />
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?<br />
<br />
Thanks<br />
<br />
<br />

</div>
</div>



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




ADO recordset does not return all column values

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.