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

where your code crashes are a valuable resource to giving advice what might be done differently (if there is something done wrong). Best regards, Bernd ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org

[sqlite] Problem using System.data.SQLite

when compiling againt .Net Framework 4.6.2. If I understand the Version history correctly it should work with dotnet core 2, or am I wrong with that? Does anybody have an idea what's wrong here? Regards Bernd Bernd Schuhmacher Development Department CRANIMAX GmbH, Amerikastrasse 14,

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 transi

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,

Re: [sqlite] Compatibility SEE and System.Data.SQLite

OK Thanks for the inof. So I know what to look for if needed. Regards Bernd Am 22.08.2016 um 12:18 schrieb Richard Hipp: On 8/22/16, Bernd Schuhmacher <bernd.schuhmac...@cranimax.com> wrote: Hi Am 19.08.2016 um 13:43 schrieb Richard Hipp: On 8/19/16, Bernd Schuhmacher <bernd

Re: [sqlite] Compatibility SEE and System.Data.SQLite

Hi Am 19.08.2016 um 13:43 schrieb Richard Hipp: On 8/19/16, Bernd Schuhmacher <bernd.schuhmac...@cranimax.com> wrote: ... No. Databases encrypted by the legacy encryption mechanism in SDS are not readable or writable with SEE, and vice versa. Thanks for the information. Is there a way

[sqlite] Compatibility SEE and System.Data.SQLite

Hi I am working on a project using the System.Data.SQLite .net Classes. I use the encryption available with this classes. Is the encryption used by System.Data.SQLite when setting a password compatible with the encryption used in the SEE version of SQLite? Regards Bernd

[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

[sqlite] R*Tree and foreign key constraints

. Alle Rechte vorbehalten. C:\Users\Bernd>sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE t_geometrie_typ ...> (au

[sqlite] documentation for datetime functions

04:23:19.120-04:00 Thanks, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] struggling with a query

ECT name, MIN(vid) AS minvid, MAX(vid) AS maxvid FROM v GROUP BY name ) Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 <be...@web.de> 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 th

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

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 leading zeros, like '01', '02' and so on. I'm reading that text out of an Oracle-DB into a SQLite

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] Unhandled Exception: System.TypeInitializationException

AAN..cctor() That looks a lot like your two systems do not have the same bitness. Could it be that your WS2008 is 64 bit? Have a look at https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki to resolve this issue. Bernd ___ sqlite-us

Re: [sqlite] Install sqlite-netFx40-setup-bundle silently

Am 27.03.2013 10:21, schrieb Jeff Williams: Is it possible and if so how to install sqlite-netFx40-setup-bundle in a silent mode. I would like to do the install as part of a software package but would prefer the users are not presented with the install screens. Also what would be the easiest

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?

should only be used in cases where the assembly binary must be deployed to the Global Assembly Cache for some reason (e.g. to support some legacy application on customer machines). " Anyone knows more? Thank you. I asked Joe Mistachkin a while back the same. Here's what he replied: Am 21.09.2012 00:3

Re: [sqlite] System.Data.SQLite.dll ?

- it's just a wrapper. Best regards, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] instr() documentation error

, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Use of different System.Data.SQLite packages

deployed beforehand. I don't use the GAC as well, but nonetheless usually deliver the statically linked mixed mode assembly that fits the user's platform together with my own assemblies. Could you elaborate on why I should avoid doing as I do at the moment? Thanks, Bernd ___

Re: [sqlite] Typo on hwaci.com website (cerod.html)

, Philip Is this good for a promotion in the grammar police? Ted, ex-IBM documentation writer. I guess, you forgot the ... tags. Bernd, not a native English speaker, nonetheless understood everything on the afore-mentioned site (but then again, that may be why I'm not so picky about gramma

Re: [sqlite] Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How?

olicy", but that doesn't work. Plus, why should I add this, knowing that version 1.0.81.0 is supposed to be built in v4.0? I've never had to mess around with any hacks, nor should you. If you don't absolutely need the VS-Integration and installed the setup, you could try uninstalling i

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

This seems to work: C:\Users\Bernd>sqlite3 SQLite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t (duration); sqlite> sqlite> insert into t values ('9:34:15:00'); sqlite> ins

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] System.Data.SQLite version 1.0.80.0 released

of how to use the Backup API from CSharp? I'm very interested in using it but have no clue how to convert the C-example on https://www.sqlite.org/backup.html to working CSharp code. Thanks, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Header inconsistency

Hi list, I found that table aliases are repeated in the headers of compound queries. Is this intentional and/or documented somewhere? I'm asking, because it forces one to either already alias the columns in the query or use the aliased column name in the DataReader (I'm using the .NET

[sqlite] Best practices for dealing with password protected database

This may not be really SQLite specific, but as it's at least SQLite related I thought I asked here. Our program ships with an encrypted SQLite database that has to be opened by the application to process some other data. As it's a .NET application, it's very easy to peek inside the source code

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?

ooks for the literal '@hash' which doesn't get replaced by the SQLite-ADO.NET provider and which of course doesn't exist in the db. Hope that helps, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Vaccum with VB,NET

uot;; command.ExecuteNonQuery(); } merry Christmas altogether, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] NFS again

Hi, I read on the wen that version 3.3 was planned to offer alternative locking to help with broken NFS implementations. I run sqlite 3.6.10-1ubuntu0.2 and it still hangs on connecting to the db file on NFS. Is this feature already implemented and how do I use it? Thanks, -- Bernd

[sqlite] problem with update trigger

values? Any help is really appreciated, thanks in advance, Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] bla

hey - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]