Android Question What is a "db escape character"

Mikelgiles

Active Member
Licensed User
Longtime User
In reference to DBUTILS escapefield() I see a reference to "db escape character" and am wondering what a "db escape character" is for. I am a pretty new at SQL and have never used sqlite at all.
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
It is important to watch the SQL video tutorial and use parameterized queries.

EscapeField is a private sub in DBUtils. Wrapping fields / columns names with square brackets allows using spaces inside the column names.
B4X: 
"Select col1, col2, col3 FROM table1" 'good
"Select [col1], [col2], [col3] FROM table1" 'also good
"Select col 1, col2, col3 FROM table1" 'not good
"Select [col 1], [col2], [col3] FROM table1" 'good

I don't recommend using spaces or other characters that need to be escaped in the column names.
 
Upvote 0

Mikelgiles

Active Member
Licensed User
Longtime User
So unless I want to include spaces in field names I dont need to use it? I have always assumed that spaces were a no-no and have never felt the need to use them. And thanks for the very quick response!
 
Upvote 0
S

sorex

Expert
Licensed User
Longtime User
you can still use an underscore instead of space if you don't want a number to be close to the text part for readability.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question [Solved] How to escape a string with the ( "$ ) characters within?
Replies
4
Views
3K
Erel
  • Locked
  • Question
Android Question Escaping Comma (,) in CSV File
Replies
11
Views
8K
Erel
B
  • Question
Android Question escape quote character
Replies
3
Views
3K
bixmatech
B
[wish]support "\" escape character
Replies
2
Views
4K
icefairy333
  • Locked
  • Article
B4A Library New Net library - Android FTP, SMTP and POP3
18 19 20
Replies
384
Views
255K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…