invoso.com Report post Posted 12/11/2013 02:13 PM Several times by pasting complete sql query into VG module SELECT *FROM (SELECT region_id, nazwaFROM medivet_bok_bokLEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok1=placowki.nazwaWHERE kierunkowy=52UNION ALLSELECT region_id, nazwaFROM medivet_bok_bokLEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok2=placowki.nazwaWHERE kierunkowy=52) as sub inserted into Evaluate expression looks: " SELECT *FROM (SELECT region_id, nazwaFROM medivet_bok_bokLEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok1=placowki.nazwaWHERE kierunkowy=$RV[id_lokalizacji]UNION ALLSELECT region_id, nazwaFROM medivet_bok_bokLEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok2=placowki.nazwaWHERE kierunkowy=$RV[id_lokalizacji]) as sub " what shows VG cut CRLF without replacing by space. Is possible to keep text formatting in each VG module (esspecially Evaluate Expression and database query) to save query structure? Share this post Link to post