Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace chr(13) + chr(10)
Message
From
01/04/2019 14:52:01
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
01/04/2019 14:41:56
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667754
Message ID:
01667815
Views:
44
Likes (1)
>>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform