In the old engine, the "general indention" could be set to 0 but in the newest version it cannot be set lower than 1. When formatting as vbstring(2) I would like to have
strSQL= "" & _
"SELECT " & _
"library.col1 as col1 , " & _
"colum as col203 , " & _
"library.largecolumn3 as col3fromcol22 , " & _
"col4||col5||'result='||col6 as col8 , " & _
"from " & _
"library " & _
"where " & _
"library.code > 111 " & _
"and library.col1 = 'abcd' " & _
"and library.col1 = 'abcd' " & _
"and library.largenumbervisitors > 250 " & _
"or ( " & _
"qty > 500 " & _
"and visitors > 555 " & _
"and nbr_days >=100 " & _
"or ( " & _
"library.visitors=2 " & _
"and nbr_days =5 ) );"
instead of
strSQL= "" & _
"SELECT " & _
" library.col1 as col1 , " & _
" colum as col203 , " & _
" library.largecolumn3 as col3fromcol22 , " & _
" col4||col5||'result='||col6 as col8 , " & _
"from " & _
" library " & _
"where " & _
" library.code > 111 " & _
"and library.col1 = 'abcd' " & _
"and library.col1 = 'abcd' " & _
"and library.largenumbervisitors > 250 " & _
"or ( " & _
" qty > 500 " & _
" and visitors > 555 " & _
" and nbr_days >=100 " & _
" or ( " & _
" library.visitors=2 " & _
" and nbr_days =5 ) );"
(i.e. no leading spaces on each line).
Is there another way to accomplish this?
Please give the new Release 6.22.05.13 a try