>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.
What version of MDAC are you using? I have MDAC 2.6 and text fields are returned on the RS just fine. Make sure that the specific row you are trying to access actually has data. If this is not your problem then you may want to post some code to better assess what is happening.
As to the table name, you can access the query string used for the RS by looking at the Source property.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement