Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() - Line is too long
Message
 
 
To
30/01/2007 09:48:49
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01190435
Message ID:
01190454
Views:
18
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform