>>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.

The where clause was there, and was not the problem. The problem appears to be not specifying number of characters returned by the cast function.
SQLEXEC(gnHnd, "UPDATE mytable SET xxNotes = CAST(xxNotes AS varchar(8000)) + ?lcNote") where... appears to be functioning

Thanks anyway
-Brett