Other Using the Editor

P

Pelky

Active Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
Use SmartStringLiteral
B4X: 
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
 
Upvote 2
P

Pelky

Active Member
Licensed User
Longtime User
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
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
B4X: 
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))
 
Upvote 1
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Delay in Time
Replies
11
Views
936
Brian Dean
B
B
Bug? Paths Configuration does not save set paths
Replies
2
Views
968
BlueMorpho
B
Java Question Java try cath in wrapper b4a
Replies
2
Views
1K
Alimoeini
  • Question
Android Question callsub and polymorphism
Replies
7
Views
2K
advansis
M
  • Question
Android Question unfiltered log
Replies
1
Views
1K
NJDude
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…