Delphi SQL Formatter

[Mujkoni 3]

SQL to Delphi code

 

Download

 

Default option is CommandText, but you can change it.

There is also option SQL.Add

Edited November 1, 2018 by Mujkoni

[Kryvich 165]

I think 5 function calls or 5 assigments is not the best code style. Consider these variants:

SQL.Add('SELECT EntCity, EntStageName' + sLineBreak
  + 'FROM Entertainers' + sLineBreak
  + 'WHERE 1=1' + sLineBreak
  + 'AND TEST=''TEST''' + sLineBreak
  + 'ORDER BY EntCity ASC, EntStageName ASC');
  
CommandText := 'SELECT EntCity, EntStageName' + sLineBreak
  + 'FROM Entertainers' + sLineBreak
  + 'WHERE 1=1' + sLineBreak
  + 'AND TEST=''TEST''' + sLineBreak
  + 'ORDER BY EntCity ASC, EntStageName ASC';

Optionally replace line breaks with spaces:

SQL.Add('SELECT EntCity, EntStageName '
  + 'FROM Entertainers '
  + 'WHERE 1=1 '
  + 'AND TEST=''TEST'' '
  + 'ORDER BY EntCity ASC, EntStageName ASC');

 

[Uwe Raabe 2057]

Recent Delphi versions also allow something like this:

    SQL.AddStrings([
      'FROM Entertainers',
      'WHERE 1=1',
      'AND TEST=''TEST''',
      'ORDER BY EntCity ASC, EntStageName ASC'
      ]);

 

[Alexander Elagin 143]

SQL.Add (or AddStrings) does not clear the previous content of the SQL text possibly producing the incorrect result. Either explicitly clear the list with SQL.Clear before adding new lines or simply use the Text property: SQL.Text := ....

[Kryvich 165]

BTW Delphi IDE has MultiPaste feature, which can paste lines adding a prefix and a suffix, and escaping quotes.

https://www.youtube.com/watch?v=ca8itZ9xXnA (Don't know how to insert Youtube video).

[Tommi Prami 130]

Pretty handy, also if it could remove the Delphi formattings so I could easily take SQL and paste it then to SQL tool to tinker with...

[Edwin Yip 154]

Try GExperts -> Editor Experts -> Paste String As.

This is a gem from GExperts. Furthermore - you have 'Copy Raw Strings' which does the opposite.

[CoMPi74 3]

On 11/7/2018 at 1:30 PM, Edwin Yip said:

Try GExperts -> Editor Experts -> Paste String As.

This is a gem from GExperts. Furthermore - you have 'Copy Raw Strings' which does the opposite.

Is it possible to modify the templates? Or are they hardcoded? I mean I would like to paste my strings as '%s +', so without 'sLineBreak +' and similar. 

[dummzeuch 1505]

2 hours ago, CoMPi74 said:

Is it possible to modify the templates? Or are they hardcoded? I mean I would like to paste my strings as '%s +', so without 'sLineBreak +' and similar. 

There is the "Convert Strings", editor expert which allows for more complex conversions.

[CoMPi74 3]

On 7/7/2023 at 6:01 PM, dummzeuch said:

There is the "Convert Strings", editor expert which allows for more complex conversions.

@dummzeuch That is exactly what I need :) Thank you

[Alberto Paganini 3]

Hello,

 

Isn't the download still available ?

Is there an alternative link ?

 

Many thanks

Alberto

Edited January 27 by Alberto Paganini