I know this is possible:
SQL_Select = "SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax FROM customers"
But in Xojo, can you do something like this:
SQL_Select = <<%str%
SELECT
CustomerID,
CompanyName,
ContactName,
ContactTitle,
Address,
City,
Region,
PostalCode,
Country,
Phone,
Fax
FROM customers
%str%
eh?
Sorry, it’s not possible to do it in line like that.
You can use a Constant and the constant editor will let you put multiple lines in, that will get handled correctly.
no
strings cant span multiple lines without splitting & appending
something like
SQL_Select = "SELECT " +_
"CustomerID, " +_
"CompanyName, " +_
"ContactName, " +_
"ContactTitle, " +_
"Address, " +_
"City, " +_
"Region, " +_
"PostalCode, " +_
"Country, " +_
"Phone, " +_
"Fax " +_
"FROM customers"
Okay, thanks for the tips.