SQL Prompt Breaks Nested REPLACE Functions Onto Multiple Lines

• 
  Hi DataJedi, 
  
  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.
  Can you try unchecking. Preserve existing empty lines between statements. 
  
  Please let know if this helps
  
  Best, 
  
  Hassan 
  Product Support Engineer 

  hassan_imam February 01, 2024 21:54

  - 0 +
• 
  Hello Hassan.
  
  I just checked, and "Preserve existing empty lines between statements" is already checked.
  
  Perhaps I can share my settings file with you?

  DataJedi February 08, 2024 13:47

  - 0 +
• 
  Hi, 
  
  Sure, also could you send us a copy of the script in question so we can test it.  
  
  

  Best,

  Hassan
  Product Support Engineer

  hassan_imam February 08, 2024 14:00

  - 0 +
• 
  Sent you message with the files.

  DataJedi February 08, 2024 14:49

  - 0 +
• 

  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?

  hassan_imam February 20, 2024 17:56

  - 0 +
• 
  Sent you message with the files. Let me know if you don't see it.

  DataJedi February 20, 2024 18:11

  - 0 +
• 
  Thank you, However the style file should be a JSON file and should be saved here: C:\Users\<YourUser>\AppData\Local\Red Gate\SQL Prompt 10\Styles. Could you send me a copy of the custom style within that directory.

  hassan_imam February 20, 2024 19:06

  - 0 +
• 
  Ok. I sent the JSON file as a ZIP file. Your messaging system does not allow uploading of JSON files.

  DataJedi February 20, 2024 19:10

  - 0 +
• 
  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.
  
  
  
  

  hassan_imam February 20, 2024 19:55

  - 0 +
• 
  Ah, okay. I can work with that. Thank you so much.

  DataJedi February 20, 2024 19:58

  - 0 +

Add comment

Please sign in to leave a comment.