>>Create Cursor test (Id Int, dummy Memo) >>Local ix, lcText >> >>Insert Into test (Id, dummy) Values (1, 'Line 1' + Chr(13)+Chr(10) +'line 2') >>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') >> >>Locate >>Browse >>>
Insert Into test (Id, dummy) Values (1, lcLines)>and the variable lcLines was in scope. But he wants the command (to be macro expanded) containing a string literal with a line break to work... well, that won't work.
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