SQLTag Query - how to type a multi line query

Ignition
1

…
to have a better readability ?
Ex.

select case when count(*)>0 then 'TRUE'
            else 'FALSE'
        end 
from t_users where name ='toto' and pwd ='titi'

instead of

select case when count(*)>0 then 'TRUE' else 'FALSE' end from t_users where name ='toto' and pwd ='titi'
2

Hi,
If you’re doing this in a area where you’re writing Python code (which offhand is the only place I can think of that might give you some trouble with formatting like this), just surround your SQL statement in a set of triple quotation marks. So, for example, you would do:

SQL = """select case when count(*)>0 then 'TRUE' 
                     else 'FALSE' 
                end 
         from t_users where name ='toto' and pwd ='titi'"""
system.db.runQuery(SQL)