>I am trying to append text to a memo field through the SQLExec statement from my VFP6.0 app. I get an error when executing a statement like the following:
>
>SQLEXEC(gnHnd, "UPDATE mytable SET xxNotes = xxNotes + ?lcNote")
>
>I also tried the following, but it only saves the first few chars:
>
>SQLEXEC(gnHnd, "UPDATE mytable SET xxNotes = CAST(xxNotes AS varchar) + ?lcNote")
>
>Any ideas? Thanks
>-Brett
You need a where clause and it can't be the memo field, it needs to be at least the primary key.
-TomC