>>>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.