Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Thank you so much for your reply. I sill surely look at the options you gave me. I ask because I run into errors a lot, using the System.Data.SQLite libraries. It easily crashes, trhows exceptions and similar issues... I found out that it matters which target platform is selected... So

Re: [sqlite] lint CLI command

Am 14.08.2018 um 20:42 schrieb Bernd Lehmkuhl: Good day altogether, I suppose there might be a problem with reporting missing indexes on foreign key columns in conjunction with the without rowid clause: C:\Users\Bernd>sqlite3 SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help&qu

[sqlite] lint CLI command

Good day altogether, I suppose there might be a problem with reporting missing indexes on foreign key columns in conjunction with the without rowid clause: C:\Users\Bernd>sqlite3 SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory

Re: [sqlite] Bug report: Wrong column name in a table in a certain case

Most probably not a bug. I asked something similar a while ago. It's as easy as https://sqlite.org/faq.html#q28 . As long as you don't explicitly assign an alias to a column name, sqlite is not guaranteed to return what you might expect. Am 11.08.2017 um 22:52 schrieb Jürgen Palm: Hi,

[sqlite] constraint failed message and no clue what went wrong

> Dominique Devienne hat am 23. Mai 2016 um 13:42 > geschrieben: > > > On Mon, May 23, 2016 at 12:22 PM, Bernd Lehmkuhl mailbox.org > > wrote: > > > > > Dominique Devienne hat am 23. Mai 2016 um 11:20 > > geschrieben: > > &g

[sqlite] constraint failed message and no clue what went wrong

> Dominique Devienne hat am 23. Mai 2016 um 11:20 > geschrieben: > > > On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl mailbox.org > > wrote: > > > [...] What might cause a "constraint failed" message following this > > command: [...] > >

[sqlite] constraint failed message and no clue what went wrong

Dear list, having the following database schema: /*** t_geometrie_typ ***/ CREATE TABLE t_geometrie_typ( auto_id INTEGER PRIMARY KEY AUTOINCREMENT, -- automatically generated id as link to the r*Tree index id TEXT UNIQUE NOT NULL, typ TEXT COLLATE NOCASE NOT NULL, objektart TEXT NOT

Re: [sqlite] struggling with a query

Am 08.02.2014 11:03, schrieb Stephan Beal: i have table containing a mapping of logic dataset versions and filenames contained in that dataset version: CREATE TABLE v(vid,name); INSERT INTO "v" VALUES(1,'foo'); INSERT INTO "v" VALUES(1,'bar'); INSERT INTO "v" VALUES(2,'bar'); INSERT INTO "v"

Re: [sqlite] System.Data.SQLite: Leading zeros being stripped off

> On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl <be...@web.de> wrote: > >> Am 15.07.2013 22:26, schrieb Simon Slavin: >>> >>> The following two statements do different things. >>> >>> INSERT INTO myTable VALUES (01) >>> INSERT INTO myTab

Re: [sqlite] System.Data.SQLite: Leading zeros being stripped off

Am 15.07.2013 22:30, schrieb Gerry Snyder: On 7/15/2013 1:18 PM, Bernd wrote: I'm reading that text out of an Oracle-DB into a SQLite table which has the affected column defined as 'String' - which maps to TEXT in native SQLite No. Look at section 2.1 of http://sqlite.org/datatype3.html

Re: [sqlite] System.Data.SQLite: Leading zeros being stripped off

Am 15.07.2013 22:26, schrieb Simon Slavin: On 15 Jul 2013, at 9:18pm, Bernd wrote: I know that SQLite is inherently type-less, but I'm using System.Data.SQLite which tries it very best to force that into the common ADO.NET schema. I'm having troubles with some text that has

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

This is not correct. It's up definitely up to date: https://system.data.sqlite.org/downloads/1.0.86.0/sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.86.0.zip Available at: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki "This binary package contains all the binaries for the

Re: [sqlite] System.Data.SQLite version for SQLite 3.7.16

Am 25.03.2013 18:37, schrieb Nicolas Rivera: Hi, The latest version of System.Data.SQLite in the download page is 1.0.84.0, which appears to have been done for SQLite version 3.7.15.2. Is that correct? If so, is there a plan to update System.Data.SQLite with the latest SQLite version?

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

Am 27.02.2013 15:28, schrieb Gilles Ganault: On Tue, 26 Feb 2013 19:45:27 -0500, Kevin Benson wrote: Right, but while the first DLL will be found since it's now part of the project (Project > Add Reference), the wiki doesn't say that this doesn't take care of the

Re: [sqlite] MIN() for a timedelta?

Am 26.07.2012 23:32, schrieb C M: I have string representations of a Python timedelta stored in an SQLite database of the form H:MM:SS:ss (the last is microseconds). Here are a possible examples of such timedeltas: '0:00:06.229000' '9:00:00.00' '10:01:23:041000' I want to select the

Re: [sqlite] System.Data.SQLite version 1.0.80.0 released

Here is a quick example that copies a small database from memory to disk: using System.Data.SQLite; namespace BackupAPI { class Program { public static void BackupAndGetData() { using (SQLiteConnection source = new SQLiteConnection( "Data Source=:memory:"))

Re: [sqlite] Multi-column unique constraint in SQLite

Am 11.09.2011 13:42, schrieb liviodl: Hi guys, I'm trying to create a multi-column unique constraint in SQLite, but I don't have success. In table "players", I've created the following index: CREATE UNIQUE INDEX "players_unique" ON "players" ("id" ASC, "skill" ASC, "stagione" ASC,

Re: [sqlite] [newbie/VB.Net + SQLite] Reliable file hashing?

Am 05.03.2010 15:34, schrieb Gilles Ganault: > In the following code, a record is added everytime, although this file > is already in the SQLite database (I checked by opening it with a > stand-alone application after running the program once): > > http://pastebin.ca/1823757 > > The problem

Re: [sqlite] Vaccum with VB,NET

Am 24.12.2009 02:16, schrieb Ernany: > Hello guys, > > How i run sqllite with VB2005 , NE|T. I need tio run *"Vacuum"*. > > Thanks a lot > > Ernany > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

[sqlite] problem with update trigger

hello list, my problem is rather related to sql in general than to sqlite but as I'm using sqlite as my db and there are so many authorities of sql in this list I thought of asking my question here. I have the following schema: CREATE TABLE T_Linien( handle TEXT , von TEXT , nach