SQL Prompt Breaks Nested REPLACE Functions Onto Multiple Lines
DataJedi
Posts: 6 New member
in SQL Prompt
Some of the stored procedures I need to reformat have statements with nested calls to the REPLACE function. My current configuration causes these nested calls to be placed on new lines, as shown in this screenshot:
I'd like to see what settings are affecting this behavior. I'd prefer to have the entire statement on one line (or as few lines as possible) so that I can manually decide where to make the line breaks.
I'd like to see what settings are affecting this behavior. I'd prefer to have the entire statement on one line (or as few lines as possible) so that I can manually decide where to make the line breaks.
Tagged:
Best Answer
-
hassan_imam
Posts: 48 Bronze 1
Hey DataJedi,
Thank you for sending over the files. After testing your script, I observed that the default style behaves consistently. However, there's flexibility to enhance it by unchecking the options within the wrapping section or specifying a character limit for wrapping as needed.
Answers
Apologies for the issues you are experiencing with SQL Prompt. If you go to SQL Prompt > Edit Formatting:
you can create a new style: The formatting which is being set is the default style unless changed prior.
Please let know if this helps
Best,
Hassan
Product Support Engineer
I just checked, and "Preserve existing empty lines between statements" is already checked.
Perhaps I can share my settings file with you?
Sure, also could you send us a copy of the script in question so we can test it.
Best,
Hassan
Product Support Engineer
Hi DataJedi,
Apologies for the delay. Could you please inform us of the active style you are currently using, or if you have a custom one configured can you send it to us?