VoiceGuide IVR Software Main Page
Jump to content

Text Formatting By Pasting

Recommended Posts

Several times by pasting complete sql query into VG module

 

SELECT *
FROM (

SELECT region_id, nazwa
FROM medivet_bok_bok
LEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok1=placowki.nazwa
WHERE kierunkowy=52
UNION ALL
SELECT region_id, nazwa
FROM medivet_bok_bok
LEFT JOIN (SELECT region_id, nazwa FROM placowki WHERE id_klienta=193 AND keeper IS TRUE)as placowki ON medivet_bok_bok.bok2=placowki.nazwa
WHERE 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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×