Question on SQL query formatting ??

Classic Servoy
1

Hi,
I am fairly new to SQL statements so forgive me if this is a stupid question,
but I have a long select statement that in servoy editor i need to constantly scroll to see the end of, what is the syntax for making the statement multi line. I have tried the following without success

'SELECT workorder_line_items.product_name AS workorder_line_items_product_name,
	workorder_line_items.product_description AS workorder_line_items_product_description, 
	workorder_line_items.product_colour AS workorder_line_items_product_colour, 
	workorder_line_items.prod_qty AS workorder_line_items_prod_qty, 
	workorder_line_items.product_cost AS workorder_line_items_product_cost, 
	workorder_line_items.sub_total AS workorder_line_items_sub_total 
	FROM workorder_line_items workorder_line_items WHERE quote_id = ?'
2

You have to terminate each line with a , so:

'SELECT workorder_line_items.product_name AS workorder_line_items_product_name,\
   workorder_line_items.product_description AS workorder_line_items_product_description,\
   workorder_line_items.product_colour AS workorder_line_items_product_colour,\
   workorder_line_items.prod_qty AS workorder_line_items_prod_qty,\
   workorder_line_items.product_cost AS workorder_line_items_product_cost,\
   workorder_line_items.sub_total AS workorder_line_items_sub_total\
   FROM workorder_line_items workorder_line_items WHERE quote_id = ?'
3

Thankyou thats great