A text type in SQL is actually a type of BLOB.
First, if you are specifying a field list, make sure you include the primary key field. Make sure the text field is the last field in the field list. This is because BLOB data is retrieved separately from the rest of your data.
You may have to use the GetChunk method to retrieve your data.
Also, starting with ADO 2.5, there is a stream object that may make it easier to read this sort of data field.
-Dave.
>Hi all
>
>I have problems reading a text column from SQLServer 7.0 from VFP 7 new release.
>
>Fro this purpose I create a connection and record set object in VFP and after it select the data from SQL Server.
>
>Completed this operation with success I prove read the text field and obtain a .NULL. Valued from SQL server, the statement I use is:
>
> oRS.fields(“metadata”).Valued && that return .null.
>
>where:
>
>metadata is the text column and oRS is the record set object created
>
>Other thing that I need know is the name(s) of the base source table of the record set and if in the record set has been selected the column metadata.
>
>Thanks for the help of any person that know the solution of this requirements.