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"
Last modified date: 12/03/2024