>
>I'm not only looking for a solution, but also why an update to an existing record is so very different then adding a new record. Is the SQL Update statement the view automatically generates different in each case? Why does the server not bark at the MEMO field when adding a new record?
>
>Thanks to anyone who can shed some light...
>
>Mario

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.