B4J Question RDC very long command Line

[alienhunter]

hi ,
is there a way that i would be able to make this command more "friendly"

sql.select_month123=SELECT EXTRACT(YEAR FROM date) AS yr,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q1,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q2,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q3 FROM transactions GROUP BY EXTRACT(YEAR FROM date);

this is only for 3 months and i have to do this for 12 ... i am out of screen's(2) width

example :

sql.select_month123=SELECT EXTRACT(YEAR FROM date) AS yr,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q1, & _
,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q1, &_
,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q1, &_
,SUM(CASE WHEN EXTRACT(MONTH FROM date) IN (?)THEN pointsreq END) AS Q1, &_
.... ...

thanks

 

[Erel]

Yes, you can use multiline values. You need to add a backslash at the end of each line. See the answer here for an example: http://stackoverflow.com/questions/...-property-value-using-propertiesconfiguration

 

[alienhunter]

Thank you
it worked