Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't store a Report FRX file in a table.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00591420
Message ID:
00597460
Vues:
21
It is working now, what I was missing is, when the example says
SQLEXEC(lnHand,'UPDATE MyTableName SET MyFRXField = ?__DATA.mData WHERE ???')

THE "__DATA." part has to be literally like that, it did not work when I used
a different alias other that '__DATA', like MyTableName.mFieldName

a GooglePlex of Thanks to you for all your help,

Happy Holidays!!!




I got that part,
>Hi Luis,
>
>The 'MyFile.cFRXField' suppoused to be a memofield with your file that you created according to faq.
>
>>Ok!, I tried that:
>>
>>I did something like
>>lnResult=(lnHandler,'UPDATE MyTableName SET MyFRXField = ?MyFile.cFRXField WHERE MyCondition')
>>
>>Then a window poped asking for the value of Myfile.cFrxFile
>>I tried typing the field name, cFrxFile, and the field name with the
>>alias MyFile.cFrxFile and it seemed to take it, but when I restore the fields back from SQL I have the same problem.
>>
>>Two questions here :
>>What am I missing now ?
>>How do I avoid the window to pop?
>>
>>Thanks a lot for your great help!
>>
>>>
>>>I you follow faq than I think it should be
lnRtnVal=SQLEXEC(lnHandler,'UPDATE MyTableName SET MyFRXField = ?__DATA.mData WHERE ???')
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform