>Hi!
>
>I did updating of memo fields through SPT some time ago, but I do not remember a single problem. Check what is "SQL WHERE" option in your SPT cursor - send only key fields in SQL Where. If you cannot solve the problem, simple SQLEXEC(nn,"UPDATE MyTable Set MyMemo=?MyVFPCursor.MyMemo WHERE ID=?MyVFPCursor.ID") is not that complex.
I know, but then I'd rather give up the updatable cursor and build a complete "Update .. Set" SQL command. Or, maybe not - if there's a 8K limit per command, and I need to do multiple records, file buffering on... doing just memos separately may do the trick. Maybe I should set these fields to something else, not Text? Uchitsya, uchitsya, uchitsya...
Nice routine, BTW. I'd probably write something like that once I found which things I need to automate. I'm still in the phase of finding what works and what doesn't.