Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Max len for a command ?
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Miscellaneous
Thread ID:
01443241
Message ID:
01443249
Views:
45
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
Previous
Reply
Map
View

Click here to load this message in the networking platform