Information générale
Titre:
Problems selecting Text column
Versions des environnements
Hay everybody and thanks in advanced for any help.
I have a table under MSSQL 2005 Express edition with a text column where I store a well formatted XML document without any XML declarations.
Under VFP 9.0 opening the table trough a VFP view the text column return it value correctly, but when I select it from a program, using the object connection return Null value.
The select statement is like the following, were KMData is the text column:
select *
from appEnv
where bclass=100
and flags='A'
and (kmdata like '%%poeta%%'
and kmdata like '%%fabio%%')
the VFP code is:
LOCAL oRS as ADODB.Recordset,oCN as ADODB.Connection
.
oCN = aApp.conObj && Get connection from a specific method.
.
cSQL = "...." && the SQL statement
oRS = oCN.Execute(cSQL)
Suivant
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