Vlczech - Tomáš Volf wrote:
> CREATE TABLE people (
> firstname TEXT,
> surname TEXT
> );
> INSERT INTO people('Tomáš', 'Surname');
>
> "SELECT * FROM people WHERE firstname LIKE ?"
> For binding I use: sqlite3_bind_text(stmt, 1, name.c_str(), -1,
> SQLITE_STATIC);
SQLITE_STATIC works only i
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?
> On May 23, 2017, at 3:31 PM, Leona Struckhoff wrote:
>
> 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 following:sqlite> sqlite3 Le
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 Struc
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: Kei
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 my
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 dire
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 fact
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 use
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 examp
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 integrity_c
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
>> called msvc.h. This file is rather gen
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 release and adding
it seem
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 include/exiv2/exv_msvc.h
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" a écrit :
> System.Dat
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?
__
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 t
17 matches
Mail list logo