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 3:26 PM, Stephen Chrzano
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 sqlite3.c to sqlite3.o
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 wrot
> 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 not sure what this
is
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,
espec
> 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 in my company use this app)
>
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
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 can find on the interne
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 post on integrating your
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 regular expressions, sure, b
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, 2017 at 3:00 PM, Peter
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" <
> sqlite-users-boun...@mail
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 SQL code is like:
>
> select * from Events where Title like '%Abc%Def%'
>
>
> 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 workaround, change the que
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 neede
15 matches
Mail list logo