The keyword FLOOR is not being upper cased in Desktop version 4.8.46



Edited 2 time(s). Last edit at 03/29/2012 06:08PM by guidomarcel.

Hi Jwk,
thanks for your feedbck. Could you please post an example how you would like it formatted?
Which DB are you working with?

Regards
Guido

I am using SQLServer 2008.
In snippet of code below I expected "floor(price.col1)" to be formatted so that it becomes FLOOR(price.col1) without having to go to the "Upper and Lower" table and adding "@FLOOR@

before formatting:

SELECT floor(price.col1) AS col1 ,
price.col2 AS col2 ,
price.col3 AS col3 ,
MAprice.col4) AS col4 ,
MAprice.col5) AS col5 ,
MAprice.col6) AS col6 ,
MAprice.col7) AS col7
FROM table_1 t1,
table_2 t2
WHERE col1 = col2
AND column_1 = small_column
AND column_3411 <= column_12_sup
AND col1 = 'Test Run'
AND column_4532 = c1.dert;

expected after formatting:

SELECT FLOOR(price.col1) AS col1 ,
price.col2 AS col2 ,
price.col3 AS col3 ,
MAprice.col4) AS col4 ,
MAprice.col5) AS col5 ,
MAprice.col6) AS col6 ,
MAprice.col7) AS col7
FROM table_1 t1,
table_2 t2
WHERE col1 = col2
AND column_1 = small_column
AND column_3411 <= column_12_sup
AND col1 = 'Test Run'
AND column_4532 = c1.dert

OK, will add it.
Thanks
Guido

It is available in the new release 4.8.49
Thanks for your feddback.