Other Using the Editor

[Pelky]

I am sorry to bother you all with this but I am at a loss. I have seen how to do this somewhere but cant find it ...

I am defining an SQL database and the definition is very long. I want to be able to continue the description onto the next line for
ease of viewing. It extends way beyond the screen width.
There is a char(s) that you use?

Please help

 

[DonManfred]

Use SmartStringLiteral

dim s as string = $"Very log string or sql-definition
going over
several
lines."$

[B4X] Smart String Literal

The "smart string" literal is a more powerful version of the standard string literal. It has three advantages: Supports multi-line strings. No need to escape quotes. Supports string interpolation. The smart string literal starts with $" and ends with "$. Examples: Dim s As String = $"Hello...

www.b4x.com

 

[mcqueccu]

You can also use underscore to break the lines or enable word wrap

 

[Pelky]

Thank you so very much...

Your assistance is much appreciated

 

[Pelky]

I did try that but it came up with errors. -- how would you split the following line?

DB.ExecNonQuery2("INSERT INTO Booking values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", Array As String(Booth, BookingsDate, TimeOfDay, Visitor, VisitorOccupation, Company, Contact, Email, Inmate, Cell, Nomis, TypeOfBooking, BookedBy, TimeIn, TimeOut, S40E, DatesBooked))

trying to read lines this long are a problem

 

[DonManfred]

DB.ExecNonQuery2("INSERT INTO Booking values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", _
Array As String(Booth, BookingsDate, TimeOfDay, Visitor, VisitorOccupation, Company, _
Contact, Email, Inmate, Cell, Nomis, TypeOfBooking, BookedBy, TimeIn, TimeOut, S40E, _
DatesBooked))