>>>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.
>>
>>How many fields do you have in the view? Can you try to change just few fields and see, if you get the same problem? (E.g. scatter name loData fields field1, field2)
>
>Ok. So far I'v got next result:
>0) My table has 219 fields
>1) If I check more then 40 fields as updatable and do Gather - tableupdate return .f.
>2) If I check all fields as updatable and in browse modify less then 40 fields - all fine.. more then 40 - tableupdate is .f.
>
>So... It seems 40 fields is limitation for single tableupdate??
Perhaps the generated command is too long. Can you try the same experiment with the CursorAdapter?
In the meantime I'll try to search here for relevant threads.
If it's not broken, fix it until it is.
My Blog