Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Max len for a command ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Divers
Thread ID:
01443241
Message ID:
01443249
Vues:
46
Try constructing the whole append command as one string, e.g

text to lcAppendCmd textmerge noshow

append from myFile FOR .....
endtext

&lcAppend

Also, you don't need to have =.f. at the end, e.g. may be you can try

FOR NOT ALLTRIM(Mutuelle.cmatricule) IN ('FirstCode','Second Code', ...)

Or just append everything and then delete the extra records.

>Hi naomi,
>
>it is the same error...
>
>How use APPEND with a big condition ?
>
>>Berhnart,
>>
>>Use macro instead of eval, e.g.
>>
>>APPEND FROM  c:\test\Temp   FOR &cCondit
>>
>>For macro the maximum length of the string is 8K.
>>
>>>Hi all,
>>>
>>>THis command does not give a error.
>>>
>>>
>>> TEXT TO THISFORM.oPrivatecParam.ccondit NOSHOW TEXTMERGE PRETEXT 15
>>>   		'/'+ ALLTR(Mutuelle.cmatricule) + '/' $ '100/200/300//200/300/
>>>        		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/' = .F.
>>>    ENDTEXT
>>> 
>>>m.ccondit = THISFORM.oPrivatecParam.ccondit 
>>>APPEND FROM  c:\test\Temp  FOR EVAL( m.ccondit )
>>>
>>>
>>>BUT
>>>
>>>this one gives a error 36 ( LEN Command > 254 carac ? )
>>>
>>>
>>> TEXT TO THISFORM.oPrivatecParam.ccondit NOSHOW TEXTMERGE PRETEXT 15
>>>   		'/'+ ALLTR(Mutuelle.cmatricule) + '/' $ '100/200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/
>>>   		/200/300//200/300//200/300//200/300//200/300//200/300//200/300/' = .F.
>>>    ENDTEXT
>>> m.ccondit = THISFORM.oPrivatecParam.ccondit 
>>>APPEND FROM  c:\test\Temp  FOR EVAL( m.ccondit )
>>>
>>>
>>>How can i turn around ?
>>>
>>>Thank in advance
>>>
>>>bernhart
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