Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
VFP MEMO field retrieved as GEN field with SQLEXEC?
I had trouble displaying content of MEMO field in my edit box (myEditBox.ControlSource=cMyCursor.myMemo gives me ERROR INSTANTIATING OBJECT: my form class will not even open).
After getting clues from many helpful people on this forum, I found out that the MEMO field was retrieved as GEN field in cMyCursor.
I'm using VFP backend, will be converting to SQL SERVER (hopefully), & I'm using SQLEXEC to get cMyCursor:
lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
"SourceDB=myDatabase.dbc;SourceType=DBC;UID=;PWD=;"
THIS.lnHandle=SQLSTRINGCONNECT(lcConnStr)
lSuccess=SQLEXEC(THIS.lnHandleERCA,"SELECT * FROM myTable","cMyCursor")
SELECT cMyCursor
BROWSE
In the BROWSE window, myMemo field (of type MEMO) comes up with the word 'GEN' instead of the familiar 'Memo', and hence myEditBox.ControlSource=cMyCursor.myMemo does not work.
How can I use the SQLEXEC to retrieve MEMO field as MEMO from a remote VFP database so that I can display the content of the MEMO field inside myEditBox???
THANK YOU ALL!
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