>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 >I think this is prepared to be run as a macro, but even then there wouldn't be a problem if macro was
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.