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