>>I don't understand why one would even want to do that. It is an abuse of macro expansion. Even if one wants to do that, still I can't see the problem (I would never prefer to do but doable):
>>
>>
>>Text to lcCommand pretext 15 noshow
>>Insert Into test (Id, dummy) Values (2, 'Line 1' + Chr(13)+Chr(10) +
>> 'Line 2' + Chr(13)+Chr(10) +
>> 'Line 3' + Chr(13)+Chr(10) +
>> 'Line 4')
>>EndText
>>
>>&lcCommand
>>
>
>I'm guessing that the goal is to create a "universal" SQL command string that could either be passed into SQLEXEC() when using SQL database, or as a macro-expanded statement if using DBFs.
The more the reason to use parameters.