Thanks!

>Hi!
>
>SendUpdates=.F. should be enough.
>
>>Your explanation makes it all make sense. Thanks! So does this mean that the NOUPDATE clause cannot be used with views that include a memo field (unless fetchmemo=.F.)? What should I do - not use the NOUPDATE clause, but set SendUpdates=.F. and leave it at that?
>>
>>Thanks!
>>Del
>>
>>>Hi!
>>>
>>>"FetchMemo" - that is. Fetching memo fields by VFP is a separate query to the SQl backend to get memo content and change the memo field in view on the internal level to update it by the content from the SQl Server. Because FPT file is opened read-only mode, operating system do not allow to change anything in the FPT file. When you open view without fetching mode, the data are queried all at once and all memo fields are already in the file just before it is opened in the read-only mode.
>>>
>>>HTH.
>>>
>>>>Using a SQL Server backend, I have suddenly started having the following problem: Any remote view that includes a memo field fails to open if the USE command includes the NOUPDATE clause. The error message is "Cannot update the cursor" (error 111). If I remove the memo field from the view, or remove the NOUPDATE clause, or set "FetchMemo" to false, all is well. Also, if I remap the view field to be a character field, then everything is fine. Change it back to memo, and the error returns.
>>>>
>>>>Any Suggestions?
>>>>
>>>>Thanks!
>>>>
>>>>Del