Hi!

When memo field is very long, it is bad idea to use it that way. As well as you require proof against the "'" character inside of the memo field - that will cause error. There is very good approach that quite a lof of VFP programmers seems miss at all (gess need a FAQ or article???). VFP allows to pass parameters to SQL Pass-Through requests using "?". This is a feature of ODBC and ODBC driver might not support it, however, in most cases following works:

mproddesc = memo field
=SQLExec(mConn, "update table1 set productdesc = ?mproddesc where productid = 'ABC'")

HTH.

>Dear all,
>
>I have a simple question. When I using Update-SQL statment alone to update a memo field, it work fine. But I change the coding into SQL Pass-Through function, it doesn't work. Sample code shown as below :
>
>Working Code :
>
>mproddesc = memo field
>Update table1 set productdesc = mproddesc where productid = "ABC"
>
>Changed Code :
>
>=SQLExec(mConn, "update table1 set productdesc = '"+mproddesc+"' where productid = 'ABC'")
>
>Is it correct? Anyone can give me some advice... Thank you for your help ...
>
>Best Regards
>
>Justy Chow
>justychow@fvihk.com