But the code below doesn't work. You cannot split a line in a string definition, the part between double quotes. sql = "surname as text, _
firstname as text, _
initials as text"
In your case you could do this: sql = "surname as text, "
sql = sql & "firstname as text, "
sql = sql & "initials as text"
If (timothy = "a bunch of letters" and Jane = "just has too much information to fit into one line") or (creed = "is not happy that jane cannot fit this one statement over multiple lines because there is no character to split the code" then
John='i don't know what to do"
else
John="still can split the code across multiple lines without a string builder. But what happens if I'm not using strings only boolean logic?"
end if
The entire bold type code cannot be see in the IDE so I need a way to present it on multiple line as seen in this editor!
But the code below doesn't work. You cannot split a line in a string definition, the part between double quotes. sql = "surname as text, _
firstname as text, _
initials as text"
In your case you could do this: sql = "surname as text, "
sql = sql & "firstname as text, "
sql = sql & "initials as text"
But the code below doesn't work. You cannot split a line in a string definition, the part between double quotes. sql = "surname as text, _
firstname as text, _
initials as text"
In your case you could do this: sql = "surname as text, "
sql = sql & "firstname as text, "
sql = sql & "initials as text"
Thanks Klaus.
That is how I'm compiling the sql strings at the moment. Bit of a pain when many long sql statements need to be processed.
Would be nice to have an append character without multiple appends to a variable