M mw71 Well-Known Member Licensed User Longtime User Dec 16, 2018 #1 Hi i found this:https://sqlite.org/android/ is it possible to do that with/in B4A? - I want to use Regex with SQLite (and Case Insensivie-> GLOB works is Case Sensitive, LIKE finds too much in some cases) - use new SQL on older Android
Hi i found this:https://sqlite.org/android/ is it possible to do that with/in B4A? - I want to use Regex with SQLite (and Case Insensivie-> GLOB works is Case Sensitive, LIKE finds too much in some cases) - use new SQL on older Android
Erel B4X founder Staff member Licensed User Longtime User Dec 17, 2018 #2 Should be possible if you build the required library. Not sure that it is worth the efforts. mw71 said: I want to use Regex with SQLite Click to expand... What is the table size? Upvote 0
Should be possible if you build the required library. Not sure that it is worth the efforts. mw71 said: I want to use Regex with SQLite Click to expand... What is the table size?
M mw71 Well-Known Member Licensed User Longtime User Dec 17, 2018 #3 Erel said: Should be possible if you build the required library. Not sure that it is worth the efforts. Click to expand... o.k., it would be (very) nice, but to "high" for me. Erel said: What is the table size? Click to expand... you mean the size of the SQL Table? it contains 11 Columns and up to 6000 Rows (in my Case, depends on user activity/work). 2 Columns contains Strings i would like search with RegEx (some special situations with special german Letters and there alternative, e.g. ß->ss,ö->oe,ä->ae....) Upvote 0
Erel said: Should be possible if you build the required library. Not sure that it is worth the efforts. Click to expand... o.k., it would be (very) nice, but to "high" for me. Erel said: What is the table size? Click to expand... you mean the size of the SQL Table? it contains 11 Columns and up to 6000 Rows (in my Case, depends on user activity/work). 2 Columns contains Strings i would like search with RegEx (some special situations with special german Letters and there alternative, e.g. ß->ss,ö->oe,ä->ae....)
Erel B4X founder Staff member Licensed User Longtime User Dec 18, 2018 #4 Create a list based on the relevant field and do it in your code. It will be not be slower than doing it in SQLite directly. Upvote 0
Create a list based on the relevant field and do it in your code. It will be not be slower than doing it in SQLite directly.
