Re: Value of TEXT field disappears when read more than once

Ranjit Singh Sandhu wrote:

> Hello,
> We are having a strange problem.
> We have Windows 2000, Visual Basic 6.0 (SP 6), MySql 4.0, MyODBC 3.51.09, ADO 
> 2.6
>
> In one the cases when we read a value of a TEXT column of MySql table, it 
> disappears after
> the first show. 
>
> I had seen one similar post by Adam Milazzo on 9 April 2004.
> But no replies.
>  
This is common to ADO (I believe).  Since "text" fields are so huge, to 
conserve memory, ADO jettisons that memory once you refer to it.  What I 
usually do is something like this...

Dim varTextFld as Variant
varTextFld = myRecordset.Field["myField"].Value

From that point on, you can do other manipulations as needed, such as...

If Is_Null(varTextFld) Then

...and...

varTextFld = Replace(varTextFld, vbCrLf, "<br />")

Hope that helps - ADO works the same way with Access (the "memo" field 
type) and the "text" field type with SQL Server.


Daniel J. Summers 
danieljs@xxxxxxxxxxx


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx