Re: [sqlite] Cannot insert a prepared bound text containing dash/dahes

In my case have to use VS C++ 6.0 32 bit. Maybe this results too that behavior. > Am 08.11.2016 um 22:05 schrieb Richard Hipp : > > Unable to reproduce the problem. My test program is this: > > > #include > #include "sqlite3.h" > int main(int argc, char

Re: [sqlite] Cannot insert a prepared bound text containing dash/dahes

Unable to reproduce the problem. My test program is this: #include #include "sqlite3.h" int main(int argc, char **argv){ sqlite3 *db; if( argc!=2 ){ fprintf(stderr, "Usage: %s FILENAME\n", argv[0]); return 1; } const char *zDb = argv[1]; unlink(zDb);

[sqlite] Cannot insert a prepared bound text containing dash/dahes

Currently i'm using sqlite 3.15.0. I run into the problem that a TEXT field of a TABLE cannot be bind to a string containing a dash. If i remove or replace the dash/dashes against any character the prepared and bind statement works fine. Here two code fragments. The demo table is like

Re: [sqlite] Merging FTS indexes

On 11/08/2016 07:32 PM, Jan Berkel wrote: I use sqlite as an application specific format to distribute data to mobile clients. The data is generated and full-text indexed (FTS5) on the server, the clients then simply download one or more compressed db files. Now I'd like to generate a

Re: [sqlite] Merging FTS indexes

Why not simply query all databases and merge the results in the application? I would think that would perform equally well, and the merging is likely straightforward to implement… On Tue, Nov 8, 2016 at 1:32 PM Jan Berkel wrote: > > I use sqlite as an application specific format

[sqlite] Fastest way to search json array values?

I'm using the JSON1 extension, and I want to find items by json array contents. This means a query like `*SELECT foo.json FROM foo, json_each(foo.json) WHERE json_each.value = "bar";*`, so basically scanning the entire table. I understand that virtual tables can not be indexed, so what other

Re: [sqlite] Command line not accepting multi-line statements.

Thanks, that worked. John Gillespie On 8 November 2016 at 14:30, Richard Hipp wrote: > On 11/8/16, John G wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the Download page - precompiled > >

Re: [sqlite] Command line not accepting multi-line statements.

On Tue, Nov 8, 2016 at 3:30 PM, Richard Hipp wrote: > On 11/8/16, John G wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the Download page - precompiled > > command-line tools :

Re: [sqlite] Command line not accepting multi-line statements.

On 11/8/16, John G wrote: > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > I downloaded version 3.15.1 from the Download page - precompiled > command-line tools : (sqlite-tools-osx-x86-3150100.zip). > > When I tried copying and pasting multiple or multi-line

[sqlite] Command line not accepting multi-line statements.

I normally use the 3.8.8.3 supplied with MacOS El Capitan. I downloaded version 3.15.1 from the Download page - precompiled command-line tools : (sqlite-tools-osx-x86-3150100.zip). When I tried copying and pasting multiple or multi-line statements from my editor (jEdit) the command-line shell

[sqlite] Merging FTS indexes

I use sqlite as an application specific format to distribute data to mobile clients. The data is generated and full-text indexed (FTS5) on the server, the clients then simply download one or more compressed db files. Now I'd like to generate a full-text index for all downloaded files on the