Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field update causes error
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00015873
Message ID:
00015941
Views:
33
>If MEMO field is updatable and you checked 'Key and Updatable fields' for SQL Where Includes Clause of View Designer' you should get exactly what you have. So you better check 'Key Fields Only' (memo is not key field by definition) and it should work. If for some reason you want to use updatable you have to split view on two (one for memo, another for other fields).
>When you INSERT record Buffer is not compared with other people' entries. But for UPDATE VFP tries to make this comparison and gets in trouble with Memo field.
>BTW I use MS-SQL Server 6.5 and found some other problem with memo field updating, regarding to back-end SQL syntax.

Thanks Edward. I'll try it out! Merry Christmas!
Mario DeMello
Halifax, Nova Scotia
Canada
mdemello@dda.ns.ca
www.dda.ns.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform