Quotes around ColumnNames  

  

0

Hi there,

I use SQLinForm foremost for reformatting ProgressSQL queries, which I use in Visual Studio.

Queries that have aliases for fieldnames that are in lowercase are in VS always converted to all UPPERCASE (which I dislike). To prevent this, I have to surround the alias for the fieldname in quotes (fieldname AS Alias -> ALIAS, Fieldname AS "Alias" -> Alias). 

Is there a way to have SQLinForm surround the alias with quotes (AS "<alias>")?

3 Answers
0

Hi Gerard,

thanks for your suggestion. I try not to do refactoring / changing the SQL syntax as there is a risk to modify the SQL in such way that the result would change.

Regards

Guido

0

How can I remove the quotes around identifiers?

Best regards

0

Hi Sven,

the SQLinForm formatter cannot remove quotes around identifiers.

Regards

Guido

Your Answer


 
Preview 0 Revisions Saved
Share:

Please Login or Register