hello,
If one line of code is long, is there a way to change it to the next line and continue writing? Long code makes it less readable.
ex)
cmd.CommandText = _
"SELECT * FROM Titles JOIN Publishers " _
& "ON Publishers.PubId = Titles.PubID " _
& "WHERE Publishers.State = 'CA'"
To break a single statement into multiple lines
Moderators: Dorian (MJT support), JRL
- Grovkillen
- Automation Wizard
- Posts: 1030
- Joined: Fri Aug 10, 2012 2:38 pm
- Location: Bräcke, Sweden
- Contact:
Re: To break a single statement into multiple lines
Use the labeltovar command.
Re: To break a single statement into multiple lines
excellent!
Now it works as i want.
Thank you Grovkillen.
Now it works as i want.
Thank you Grovkillen.
Re: To break a single statement into multiple lines
Could one of you post an example?
Re: To break a single statement into multiple lines
Yes I will post an example for others.
Ex)
In the case of the example above, you can change it to:
Ex)
Code: Select all
MDL>text1%CRLF%text2%CRLF%text3%CRLF%text4%CRLF%text5%CRLF%text6%CRLF%text7%CRLF%text8
Code: Select all
/*
Text:
text1
text2
text3
text4
text5
text6
text7
text8
*/
LabelToVar>Text,MyText,1,0,*/
MDL>%MyText%