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

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

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

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

> 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

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

> 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

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

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

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

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

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

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

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

> 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

[sqlite] Simple Search using LIKE or something else

I've written Win32 desktop alarm clock that can store unlimited number of alarms (Pending drive space, of course). The problem I'm having is that right now, I've got about 20 alarms for things I need to do over the next couple of weeks that its getting harder to find what I need to update if