Android Question SQLite Like

Robert Valentino

Well-Known Member
Licensed User
Longtime User
I have a SQLite DB that has a bunch of prefixes in it I want to see if the line I have matches one or more of the prefixes

Cannot figure out how to say something like this

B4X: 
"Select * for PrefixFile where <line> LIKE PrefixData%"     ' where PrefixData is a Field in the PrefixFile that I want to LIKE on

Can the SQLite Column be on the right side of this statement?
'
 
Sort by date Sort by votes

aeric

Expert
Licensed User
Longtime User
You mean the matching should starts with value in PrefixData column?
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
Data:
line PrefixData
B4X IDEs consists of B4A, B4i, B4J and B4R.B4X
B4A is an IDE to build Android apps.Android
Android Studio is very complicated.Android

SQL: 
SELECT * FROM PrefixFile WHERE line LIKE PrefixData||'%'

Results:
linePrefixData
B4X IDEs consists of B4A, B4i, B4J and B4R.B4X
Android Studio is very complicated.Android
 
Upvote 0

Robert Valentino

Well-Known Member
Licensed User
Longtime User
Found the error in my code thanks to Aeric. I wasn't putting the quotes around the % sign
Had this
B4X: 
$"select * for PrefixFile where ${line} LIKE PrefixData || %"$
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4J Tutorial [B4X] B4XTable sample working with SQLite
Replies
7
Views
1K
aeric
Wish [SOLVED] Add optional prefix and suffix to window title using b4xV5.ini
Replies
2
Views
1K
Sandman
  • Article
B4A Library [B4X] [XUI] AS TextFieldAdvanced - Title, Information, Counter, Password, Button, Prefix, Suffix, Icons, Multiline
6 7 8
Replies
144
Views
54K
Alexander Stolte
  • Article
Android Code Snippet [B4X] SQLite case insensitive searches with non-ASCII text
Replies
0
Views
4K
Erel
  • Locked
  • Question
Other [new feature] Three birds with one stone
2
Replies
31
Views
39K
Informatix
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…