>>>Macro substitution sadly does not work and the string length is too long for concat process.
>>>How would you create my view with my vars?
>>
>>text to lcSQLCmd textmerge noshow
>> ... substitute all variables with <<var>>
>>endtext
>>
>>then
>>
>>&lcSQLCmd
>>
>>Or if the length of lcSQLCmd exceeds 8K:
>>
>>execscript(lcSQLCmd)
>
>Not working
>lcSQLCmd variable does not exist at macro attempt
>execscript is not an option in VFP6
>
>I defined lcSQLCmd but the macro still fails.
>
>What am I missing here?
text to unfortunately was introduced in VFP8 version. I guess you would have to create your lcSQLCommand in pieces then, or use textmerge command slightly different way.
Or just generate it into file and then run it.
If it's not broken, fix it until it is.
My Blog