Re: [sqlite] Simple Search using LIKE or something else

2017-11-14 Thread Stephen Chrzanowski
Thanks Warren. I'll bookmark this and have a read over it maybe this weekend. (Busy work week, and I'd just rather chill with Factorio, The Crew, or some other thing that lowers the stress. :] ) On Tue, Nov 14, 2017 at 10:58 AM, Warren Young wrote: > On Nov 13, 2017, at

Re: [sqlite] Simple Search using LIKE or something else

2017-11-14 Thread Warren Young
On Nov 13, 2017, at 3:26 PM, Stephen Chrzanowski wrote: > > I'm not using a C compiler. This article appears to sort that out: http://rvelthuis.de/articles/articles-cobjs.html Basically, you download the free CLI-only version of the C++Builder Berlin compiler, build

Re: [sqlite] Simple Search using LIKE or something else

2017-11-13 Thread Stephen Chrzanowski
I'm not using a C compiler. Delphi Berlin doesn't compile C, AFAIK. I'll play around with that tonight as I've got a project I need to start up tonight. Third party libraries include those like LiteDAC, or DISQLite3, or Synopse mORMot framework. On Mon, Nov 13, 2017 at 1:34 PM, Jens Alfke

Re: [sqlite] Simple Search using LIKE or something else

2017-11-13 Thread Jens Alfke
> On Nov 11, 2017, at 3:41 PM, Stephen Chrzanowski wrote: > > Although there are pay for, and free to use, libraries that can be > linked into my applications, I've never been satisfied with the code > provided. Hm, I didn’t say anything about 3rd party libraries, so I’m

Re: [sqlite] Simple Search using LIKE or something else

2017-11-11 Thread Stephen Chrzanowski
Thanks all for the info. I'm still doing thought wrestling on the path I want to take. On one hand, its brain dead simple for me to go the tokenizer route and have my application dynamically generate the SQL string, I just don't like that kind of code style as there are many faults with it,

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Jens Alfke
> On Nov 10, 2017, at 6:50 AM, Peter Da Silva > wrote: > >> I'm using the amalgamation by default, so I don't think FTS is in the DLL. >> I can recompile, but that now introduces complications on machines that may >> not have this exact DLL. (A couple people

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Peter Da Silva
Looking back through the thread, from the original post: > I'm using the amalgamation by default, so I don't think FTS is in the DLL. I > can recompile, but that now introduces complications on machines that may not > have this exact DLL. (A couple people in my company use this app) The same

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Richard Hipp
On 11/10/17, Stephen Chrzanowski wrote: > I'd take regular expressions, sure, but, how do you get SQLite syntax > to take that on? Load the regexp extension here (https://www.sqlite.org/src/artifact/a68d25c659bd2d89) or one of the other 3rd-party regexp extensions that you

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
A good StackOverflow post on adapting in C# for use in Linq queries: https://stackoverflow.com/questions/24229785/sqlite-net-sqlitefunction-not-working-in-linq-to-sql/26155359#26155359 On Fri, Nov 10, 2017 at 8:31 AM, Don V Nielsen wrote: > Brent Ashley has a nice blog

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
Brent Ashley has a nice blog post on integrating your languages regular express processing into sqlite: http://www.ashleyit.com/blogs/brentashley/2013/11/27/using-regular-expressions-with-sqlite/ On Fri, Nov 10, 2017 at 8:15 AM, Stephen Chrzanowski wrote: > I'd take

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Stephen Chrzanowski
I'd take regular expressions, sure, but, how do you get SQLite syntax to take that on? On Fri, Nov 10, 2017 at 8:45 AM, Don V Nielsen wrote: > Assuming you are looking for "Abc" or "Def" anywhere in the argument, how > about regular expression? (Abc|Def) > > On Thu, Nov 9,

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
Assuming you are looking for "Abc" or "Def" anywhere in the argument, how about regular expression? (Abc|Def) On Thu, Nov 9, 2017 at 3:00 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" < >

Re: [sqlite] Simple Search using LIKE or something else

2017-11-09 Thread Peter Da Silva
On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" wrote: > I've added a simple filter function that uses SQLites LIKE operator, but I'd > like something a little bit more advanced. Right now, the

Re: [sqlite] Simple Search using LIKE or something else

2017-11-09 Thread Jens Alfke
> On Nov 9, 2017, at 12:50 PM, Stephen Chrzanowski wrote: > > Is there any trick I can use that'll return AbcRfeDef and FedRfeAbc if > the two keywords are Abc and Def from a SQL call? Use full-text search (FTS4 or FTS5). This is exactly what it’s for. Or as a hacky