General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only