Hi Dennis,

That does seem odd. Glad you got it working.

Bruce

>Bruce,
>Finally, I thinking you are right and your solution is correct. In my database its not work untill I delete localview from DBC container and recreate it with another name!! (if I used old name - I had again not correct behaviour).. strange..
>
>Thanks
>Denis
>
>
>>Hi Dennis,
>>
>>In the view designer try ticking the 'Key fields only' box for the SQL Where Clause.
>>
>>Bruce
>>
>>>Hello,
>>>I have a local view. This local view return 1 record for Where clause. Buffering is 3
>>>I make nearly next in my app
>>>Select(MasterCursor)
>>>SCATTER NAME loData MEMO
>>>SELECT(LocalViewCursor)
>>>GATHER NAME loData MEMO
>>>TABLEUPDATE(0,.T.,LocalViewCursor)
>>>
>>>The tableupdate return .f. and error message is "String is too long"
>>>
>>>What this error means ? :-0
>>>
>>>Thanks
>>>Denis.