Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate() - Line is too long
Message
 
 
À
30/01/2007 09:48:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01190435
Message ID:
01190454
Vues:
17
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform