Take a look at MSKB#Q180368.

>Hay gays
>
>I have a problem reading a text field from MS SQL Server 7.0 in the new VFP 7, the scenario is this:
>
>I have a table with a column type “text” to record some text in XML format that represent meta data definitions for the application that actually I develop.
>
>The middle tier of it we are developing with VFP 7. We develop a COM object that have the functionality of get the metadata definition and convert it from XML to a VFP object that represents the communication area between presentation layer and db layer.
>
>The particularity of the object is that implement the interface of the ADO object with the objective of capture, in particular, the events relative to the navigation of the cursor to update the properties of the object derived from the metadata.
>
>The problem that I have if return or read the text column from the SQL table, after create the connection and record set object, that return .NULL., the code that I use for this purpose is, after the success creating the record set:
>
>oRS.fields("metadata").Value && that return a beautiful .NULL.
>
>Any want can help me
>
>Thanks