User Guide : Scripting : Writing Expressions : Continuing Lines in Expressions
 
Share this page                  
Continuing Lines in Expressions
Sometimes expressions are so long that you cannot view them without scrolling. To view your expressions broken into viewable segments, use the following syntax:
<space><underscore><carriage return line feed>
Also, do the following in your expressions:
use an ampersand "&" to concatenate strings together
include spaces in strings so that words are properly separated (spaces are added to the end of each line in the example below)
Example
var.SQLStatement = "SELECT * " _
& "FROM TABLENAME " _
& "WHERE COLUMNNAME = VALUE"
The resultant query looks like this:
var.SQLStatement = "SELECT * " & "FROM TABLENAME " & "WHERE COLUMNNAME = VALUE"