Re: [sqlite] vtable and usable constraint

It should be possible to use SQLite's own statistics tables to arrive at the "selectivity" of a given combination of constraints, but since I am using only virtual tables over external data I have not looked into the structure and meaning of the values stored there. You would also have to keep

Re: [sqlite] Minor issue: compile error with 3.19 and MSVC 2005

> Am 22.05.2017 um 23:52 schrieb Wolfgang Enzinger : > > Hallo, > > I don't think this is a big deal, but probably helpful for one or another: > > I tried to compile SQLite 3.19 with MSVC 2005 and got a compile error C2143 > at line 143542 of sqlite3.c. I run into the

[sqlite] msvc.h

Hi all, As of sqlite3 version 3.19.0 it appears that there is a new header file called msvc.h. This file is rather generically named and might cause conflicts with other packages. It would be useful to either rename it and/or put it into a subdirectory: e.g. exiv2 uses

Re: [sqlite] msvc.h

On 5/23/17, Marius Schamschula wrote: > > As of sqlite3 version 3.19.0 it appears that there is a new header file > called msvc.h. This file is rather generically named and might cause > conflicts with other packages. > Yes. I found the need for that file just prior to

Re: [sqlite] msvc.h

Richard, Thanks for the explanation! I’ll leave the MacPorts Portfile as it is. > On May 23, 2017, at 11:40 AM, Richard Hipp wrote: > > On 5/23/17, Marius Schamschula wrote: >> >> As of sqlite3 version 3.19.0 it appears that there is a new header file

Re: [sqlite] Is this a problem?

The command prompt here means your CMD.EXE (Windows) or *nix shell... you must use sqlite3.exe [dbfile] to get the sqlite shell to use PRAGMA integrity_check; *command prompt>* sqlite3 [database filename] sqlite3> PRAGMA integrity_check; sqlite3> .quit On Tue, May 23, 2017 at 7:40 PM, Leona

Re: [sqlite] Is this a problem?

Yah! when i did the .open leona.rmgc and then entered pragma integrity_check;I got OK  thank you From: Jens Alfke To: SQLite mailing list Sent: Tuesday, May 23, 2017 5:55 PM Subject: Re: [sqlite] Is this a problem?

Re: [sqlite] Is this a problem?

Rootsmagic is a free geneology software, so you can not enter direct commands.   They have a integrity check option in their database tools.  And it comes back ok.  If there is a command line option, I have not found it yet. LOL..My monitor is not upside down and I could read it. From:

Re: [sqlite] Is this a problem?

> On May 23, 2017, at 3:31 PM, Leona Struckhoff wrote: > > I placed the Leona.rmcg file in the same folder as the sqlite3.exeI double > clicked on sqlite3.exeI noticed my comand prompt had sqlite and not sqlite3. > Your examples below have sqlite3. > I entered the

[sqlite] UTF8 LIKE stranges

Hello, I have some strange behaviout in LIKE query in SQLite. Letš see some very simplified example:   Let's have a table CREATE TABLE people (   firstname  TEXT,   surname TEXT ); and in it following data: INSERT INTO people('Tomáš', 'Surname'); created by sqlite3_exec() function.     Then I

Re: [sqlite] UTF8 LIKE stranges

Sorry for "spam", I hope that previous HTML form of mail (with bullet lists) will be readable. There is, for sure and better readability for non-HTML clients, plain text version of previous mail:   Hello, I have some strange behaviout in LIKE query in SQLite. Letš see some very simplified

[sqlite] Is this a problem?

I am new to SQite. I am not new to queries. I am a 28 year QA Tester. I have been doing queries and macros for the past 25 years. I ran the following query over my RootMagic 7 (Version 7.22.3.0 – 24 Jan 2017)database in SQLite Spy (Version 1.9.11 Win32): --integritycheck.sql PRAGMA

Re: [sqlite] Is this a problem?

On 23 May 2017, at 6:07pm, moma...@yahoo.com wrote: > > I ran the following query over my RootMagic 7 (Version 7.22.3.0 – 24 Jan > 2017)database in SQLite Spy (Version 1.9.11 Win32): Neither of these matter. Neither of these tell you which version of SQLite they’re running. However, the

Re: [sqlite] Is this a problem?

I would suggest following up with RootMagic and see if they have overloaded one of the builtin collation sequences (NOCASE comes to mind) with something else -- perhaps something that knows how to do Case Insensitive and Accent Insensitive across the entire Unicode spectrum. Can you issue

Re: [sqlite] Is this a problem?

I downloaded sqlite-tools-win32-x86-319.zip from this site:  https://sqlite.org/download.html I unzipped it.sqldiff.exe, sqlite3.exe and sqlite3_analyzer.exe were placed in the folder I placed the Leona.rmcg file in the same folder as the sqlite3.exeI double clicked on sqlite3.exeI noticed

Re: [sqlite] SQLite on .NET Standard

Hi, For DotNet core, there is an implementation of sqlite for entity framework. maybe you can dig the dependencies to find the sqlite packages. I remember to have done this some time ago, worked well, but some features missing. Damien Le 23 mai 2017 21:04, "Mark Raymond"

[sqlite] SQLite on .NET Standard

System.Data.SQLite is available for .NET Framework 2.0+, but as far as I can tell it does not support .NET Core or .NET Standard. Are there any plans to bring System.Data.SQLite to .NET Standard, or failing that .NET Core, so that I can write cross-platform .NET code using SQLite?