Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Insert from a cursor does not copy memo field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01413645
Message ID:
01413699
Views:
48
Hi John,

>I I have a cursor with some memo fields. When I try to use SQL Insert to save the data the memo fields are not updated.

This would happen if you use the INSERT INTO FROM MEMVAR | NAME command. If you create the scatter object or memory variables with a SCATTER statement you have to include the MEMO keyword, otherwise it would appear as if memo fields are not updated.
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform