Re: [sqlite] system.data.sqlite example code?

I think this is an informative post and knowledgeable. I would like to thank you for the efforts you have made in writing this article Packers and Movers in Delhi - [url=https://www.aryawartapackers.com]packers and movers in delhi[/url] -- Sent from: http

Re: [sqlite] System.Data.SQLite Verson 111

ished.   Urs   Gesendet: Montag, 13. Januar 2020 um 20:12 Uhr Von: "Urs Wagner" An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] System.Data.SQLite Verson 111 Hello   Can I download somewhere System.Data.SQLite Version 111 (the older version). I should generete a edmx of an ex

[sqlite] System.Data.SQLite Verson 111

Hello   Can I download somewhere System.Data.SQLite Version 111 (the older version). I should generete a edmx of an existing database.   Thanks Urs ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/

[sqlite] System.Data.SQLite version 1.0.112.0 released

System.Data.SQLite version 1.0.112.0 (with SQLite 3.30.1) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

Re: [sqlite] system.data.sqlite example code?

Nice to see about the information here, thanks for sharing https://trainsrunningstatus.live -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mai

[sqlite] System.Data.SQLite version 1.0.111.0 released

System.Data.SQLite version 1.0.111.0 (with SQLite 3.28.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

Re: [sqlite] system.data.sqlite example code?

Thanks for your post, If you want to know more about Programming or want Programming Help , We are here 24*7 - [url=https://www.greatassignmenthelp.com/programming-assignment-help]Programming Help[/url] -- Sent from: http:

[sqlite] System.Data.SQLite version 1.0.110.0 released

System.Data.SQLite version 1.0.110.0 (with SQLite 3.27.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.Sqlite Encryption Cipher

Hi, Would anyone be able to confirm what encryption cipher is used when SetPassword="" is set on database creation? Regards, Paul ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/

[sqlite] [System.Data.SQLite] BusyTimeout and DefaultTimeout are not picked up from the connection string

Hello, The question is related to the System.Data.SQLite library's connection string parsing. We have defined the connection string as follows: data source=;DateTimeKind=Utc;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory;busytimeout=30001;default timeout=31 When a new SQLiteConnecti

[sqlite] System.Data.SQLite version 1.0.109.0 released

System.Data.SQLite version 1.0.109.0 (with SQLite 3.24.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki This release features

Re: [sqlite] System.Data.SQLite version 1.0.108 - .NET 2.0 no service pack compatibility

It may work without Service Pack 2; however, it has not been tested in that configuration. Sent from my iPhone > On Jun 20, 2018, at 7:45 AM, Bianchi Lorenzo > wrote: > > Hi everybody, > > We are currently using the SQlite.dll version 1.0.98 x86 for .NET 2.0, and it > seems to be working a

[sqlite] System.Data.SQLite version 1.0.108 - .NET 2.0 no service pack compatibility

Hi everybody, We are currently using the SQlite.dll version 1.0.98 x86 for .NET 2.0, and it seems to be working also on old PCs with .NET 2.0 basic, without Service Pack. We are thinking to upgrade to version 1.0.108 since it has support for both x86 and x64, but I don't know if Service Pack 2

[sqlite] System.Data.SQLite version 1.0.108.0 released

System.Data.SQLite version 1.0.108.0 (with SQLite 3.22.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.107.0 released

System.Data.SQLite version 1.0.107.0 (with SQLite 3.22.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.106.0 released

System.Data.SQLite version 1.0.106.0 (with SQLite 3.21.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.106.0 pre-release packages now available

Pre-release packages of System.Data.SQLite version 1.0.106.0 are now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Please click on the "Pre-Release Download" link in order to view the available pre-release packages. Further information about this upcoming rel

[sqlite] System.Data.SQLite version 1.0.105.2 released

System.Data.SQLite version 1.0.105.2 (with SQLite 3.19.3) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.105.1 released

System.Data.SQLite version 1.0.105.1 (with SQLite 3.18.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.105.0 released

System.Data.SQLite version 1.0.105.0 (with SQLite 3.18.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

Re: [sqlite] System.data.SQLite documentation

(GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] System.data.SQLite documentation I am not able to read SQLite.NET.chm, I see only the left hand panel, but not the expanded contents.  Is this a known issue, or perhaps an issue with Windows 7? Is this documentation available anywh

Re: [sqlite] System.data.SQLite documentation

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Mickey Feldman > Sent: Thursday, February 23, 2017 7:46 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] System.data.SQLite documentation &g

[sqlite] System.data.SQLite documentation

I am not able to read SQLite.NET.chm, I see only the left hand panel, but not the expanded contents. Is this a known issue, or perhaps an issue with Windows 7? Is this documentation available anywhere else or in some other format? -- M. Feldman --- Vigil Health Sol

[sqlite] System.Data.SQLite: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column

Windows 7 64bit SQLite version 3.17.0 sqlite-netFx46-static-binary-x64-2015-1.0.104.0 Note: The code is working correctly with Devart ODBC driver for SQLite 2.1.4 The problem is with System.Data.SQLite How to reproduce: ON SQLite Create database N:\SqLite\outStream.db CREATE TABLE FromNum (id in

[sqlite] System.Data.SQLite version 1.0.104.0 released

System.Data.SQLite version 1.0.104.0 (with SQLite 3.15.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

Thanks, Jens. I'll keep an eye on that. Take care, Melody -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Monday, December 12, 2016 12:32 PM To: SQLite mailing list Subject: Re: [sqlite] System.Data.S

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

> On Dec 12, 2016, at 5:00 AM, Baugher, Melody wrote: > > string passwordPragma = "PRAGMA key='" + password + "';"; Not quoting the password string leaves you open to SQL injection attack. This probably isn’t an issue in an internal development tool, but if there’s any code like this in

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

On 12 Dec 2016, at 1:00pm, Baugher, Melody wrote: > Starting with an encrypted database, if I run this code twice in a row with > applyPassword=false, the password is removed the first time but then applied > the second time. Your program is weird and buggy. There is one big test in the prog

[sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

My SQLite databases are encrypted at build time. Small tools were developed to remove or apply the password to all 9 databases after build to facilitate the work of the database developers. The tools run the following bit of code against each database: string activatePragma = "PRAGMA acti

[sqlite] System.Data.SQLite version 1.0.102.0

In SQLiteFunction.cs : internal static bool UnbindAllFunctions(... ... else { // // NOTE: Need to use a copy of the function dictionary in this method // because the dictionary is modified within the UnbindFunction //

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

A follow-up on this (and a late thanks!): I've used your answer to write some build instructions for Ubuntu and Raspbian at http://blog.wezeku.com/2016/10/09/using-system-data-sqlite-under-linux-and-mono/ I've also modified the F# SQLProvider type provider so that it no longer always loads Mono

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

John Reynolds wrote: > > My question is: what are the trade-offs of not using > SQLite.Interop.dll? > There are various compile-options and extensions baked into the "SQLite.Interop.dll" that are not enabled and/or included by default with "sqlite3.dll". One that is somewhat important, is the

[sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

Hi, (Sorry if this becomes a double post - I first tried posting from Nabble) I've compiled System.Data.SQLite.dll with the "/property:UseSqliteStandard=true" option, so that it will load sqlite3.dll (or it's Linux equivalent) instead of SQLite.Interop.dll. The advantage of this is that you can

[sqlite] System.Data.SQLite version 1.0.103.0 released

System.Data.SQLite version 1.0.103.0 (with SQLite 3.14.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite and Entity framework 5

Is there a way to work with System.Data.SQLite with Entity framework 5? Latest version for .net framework 4.5 requires EF6, bit I need to work with EF5. Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] System.Data.SQLite

Through DBContext constructor I have associated the connection. As the table is not existing in my database, it throws an exception. Does sqlite support automatic creation of tables or do I have create the tables and relationships first and then insert the data using the framework? On Fri, Aug 19

[sqlite] System.Data.SQLite

Hi, I am trying to use SQLite with EntityFramework6 on a .Net application. I have referred the documentation, created the app.config file as specified in the documentation. When I created a sample C# file as in the documentation,it generates an empty database file. DbProviderFactory fact = DbPro

[sqlite] System.Data.SQLite version 1.0.102.0 released

System.Data.SQLite version 1.0.102.0 (with SQLite 3.13.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

Re: [sqlite] [System.Data.SQLite] Nuget 3 support

Jann Roder wrote: > > Nuget 3 now seems to have much better support for native libraries. > I'd really like to use this for System.Data.SQLite. I suspect this will require a great deal of investigation, refactoring, and debugging. It's too late in the release cycle for 1.0.102.0 for this. I'll

[sqlite] [System.Data.SQLite] Nuget 3 support

Hi, I recently migrated two of our solutions to nuget 3. Nuget 3 now seems to have much better support for native libraries. Unfortunately it is incompatible with the way the SQLite package currently does things. I had to manually call the traget that copies the interop libraries in my .csproj f

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

On 05/24/2016 01:16 AM, Joe Mistachkin wrote: > Jason Doherty wrote: >> CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx, >> miny, maxy); >> >> fails with >> >> SQLite error (1); no such table: main.sqlite_stat1 >> > Could you run the SQL query "ANALYZE;" on the databa

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

Jason Doherty wrote: > >CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx, > miny, maxy); > > fails with > >SQLite error (1); no such table: main.sqlite_stat1 > Could you run the SQL query "ANALYZE;" on the database and see if that clears the issue? -- Joe Mistach

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

Hi We?ve used SQLite rtree indexes successfully on iOS and Android for creating spatial indexes in the past. We can?t seem to make them work on Windows. We are using the System.Data.SQLite ADO.NET library that was downloaded using the NuGet package manager (version 1.0.101) per the instructions,

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

> I am able to recreate the exception here. The value of Int64.MaxValue is > 9223372036854775807. The UnixEpoch values are measured in seconds from > the epoch 1970-01-01 00:00:00Z. Adding 9223372036854775807 seconds to the > UnixEpoch would result in a DateTime far beyond the allowed maximum va

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe Mistachkin Sent: 28 April 2016 19:54 To: 'SQLite mailing list' Subject: Re: [sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used Jann Roder wrote: > > I jus

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

Jann Roder wrote: > > I just tested the new version that should have the fix for this and now > I get an ArgumentOutOfRangeException exception when I actually have a > value of Int64.MaxValue in a date column. Stack trace: > I am able to recreate the exception here. The value of Int64.MaxValue

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

To: 'SQLite mailing list' Subject: Re: [sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used Jann Roder wrote: > > When I set the dateformat to unixepoch the maximum date I can get back > from a query is 2038-01-19. This appears to be a problem

[sqlite] System.Data.SQLite version 1.0.101.0 released

System.Data.SQLite version 1.0.101.0 (with SQLite 3.12.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite version 1.0.100.0 released

>> On Apr 15, 2016, at 12:46, Tim Uy wrote: >> >> that is a lot of 1s and 0s. > On 15 Apr 2016, at 10:34pm, Brad Stiles wrote: > > It's *all* 1s and 0s. Hate them. Simon.

[sqlite] System.Data.SQLite version 1.0.100.0 released

It's *all* 1s and 0s. > On Apr 15, 2016, at 12:46, Tim Uy wrote: > > that is a lot of 1s and 0s. > >> On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin >> wrote: >> >> >> System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) is now available >> on the System.Data.SQLite website: >> >>

[sqlite] System.Data.SQLite version 1.0.100.0 released

I think it's an Elias omega code. On Fri, Apr 15, 2016 at 11:46 AM, Tim Uy wrote: > that is a lot of 1s and 0s. > > On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin > wrote: > > > > > System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) is now > available > > on the System.Data.SQLite webs

[sqlite] System.Data.SQLite version 1.0.100.0 released

that is a lot of 1s and 0s. On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin wrote: > > System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) is now available > on the System.Data.SQLite website: > > https://system.data.sqlite.org/ > > Further information about this release can be seen

[sqlite] System.Data.SQLite version 1.0.100.0 released

System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] "System.Data.SQLite" Version 1.0 Supportability

Hi Team, We are planning to migrate few Vendor based applications from Windows Server 2003 to the latest server Operating System Windows Server 2012/2008. Before migration we would like to do the assessment of the application and check the supportability. We are performing the assessment for: Ap

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

Hi, When I set the dateformat to unixepoch the maximum date I can get back from a query is 2038-01-19. This appears to be a problem in the wrapper as SQLite itself is using 64bit integers for dates. You can reproduce the problem like this: [Test] public void ShouldDoSparseTimeSeriesTransform2()

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

Jann Roder wrote: > > When I set the dateformat to unixepoch the maximum date I can get back > from a query is 2038-01-19. This appears to be a problem in the wrapper > as SQLite itself is using 64bit integers for dates. > Thanks for the clear and concise report. This issue should now be fixed

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

ained a flaw like this. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe Mistachkin Sent: 04 January 2016 15:43 To: SQLite mailing list Subject: Re: [sqlite] System.Data.SQLite: Inco

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

Jann Roder wrote: > > Well, it doesn't really matter what the documentation says. > Unfortunately, the ADO.NET documentation is the primary source on how to implement compatible providers. Are you aware of better sources? > > I can easily patch this on my end using an IDataReader implementa

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

Mistachkin Sent: 31 December 2015 17:45 To: 'SQLite mailing list' Subject: Re: [sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable() Jann Roder wrote: > > The implementation of GetSchemaTable() in SQLiteDataReader seems to be > based on th

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

-Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Joe > Mistachkin > Sent: 31 December 2015 17:45 > To: 'SQLite mailing list' > Subject: Re: [sqlite] System

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

Hi, The implementation of GetSchemaTable() in SQLiteDataReader seems to be based on the properties of the columns used in the select. Obviously uniqueness, nullness and primary key properties do not transfer when only a subset of the columns is selected or combined with data from other tables. U

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

Jann Roder wrote: > > The implementation of GetSchemaTable() in SQLiteDataReader seems to be > based on the properties of the columns used in the select. Obviously > uniqueness, nullness and primary key properties do not transfer when > only a subset of the columns is selected or combined with da

[sqlite] System.Data.SQLite version 1.0.99.0 released

System.Data.SQLite version 1.0.99.0 (with SQLite 3.9.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLi

[sqlite] System.Data.SQLite How to activate Progress event?

Hi all, I am using System.Data.SQLite, currently 1.0.98.1, with EntityFramework 6.1.3. I want to make use of the SQLiteConnection.Progress event but can't get it to fire. I've set SQLiteConnection.ProgressOps to 1, 2 or 10, to no avail. I have also tried the other SQLiteConnection events. Stat

[sqlite] System.Data.SQLite How to activate Progress event?

Roland Ziegler wrote: > > I want to make use of the SQLiteConnection.Progress event but can't get > it to fire. I've set SQLiteConnection.ProgressOps to 1, 2 or 10, to no > avail. > As long as the event is set and the number of ops is greater than zero, it should work. Perhaps the Entity Frame

[sqlite] System.Data.SQLite version 1.0.98.0 released

> > System.Data.SQLite version 1.0.98.0 (with SQLite 3.8.11.1) is now available > on the System.Data.SQLite website: > Great news, thanks Joe!! Regards Steffen

[sqlite] System.Data.SQLite version 1.0.98.0 released

System.Data.SQLite version 1.0.98.0 (with SQLite 3.8.11.1) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the S

[sqlite] System.Data.SQLite 1.0.98.0 release

Hi, is there any target date when the preRelease branch gets over to a actual release? Is a really hard show stopper for our development at the moment. We checked everything for compatibility before merge your current trunk to Visual Studio 2015 and we forget about the SQLite design tool. :(

[sqlite] System.Data.SQLite 1.0.98.0 release

If everything goes as planned, it should be out later today (US Pacific Time). Sent from my iPhone > On Aug 19, 2015, at 4:37 AM, Steffen Mangold powerdoo.com> wrote: > > Hi, > > is there any target date when the preRelease branch gets over to a actual > release? > > Is a really hard show s

[sqlite] System.Data.SQLite preRelease branch

Steffen Mangold wrote: > > Until final release I want to download the preRelease [e670692d90] > created for 18 days. > Joe Mistachkin wrote: > > Normally, the "preRelease" branches are just a staging area for changes > needed during the release process. > > If packages are available for a pre

[sqlite] System.Data.SQLite preRelease branch

Hi, on the "News" site I see the update with support of Visual Studio 2015 is scheduled for some day in near future. Until final release I want to download the preRelease [e670692d90] created for 18 days. When I try to download the "sqlite-netFx46-setup-bundle-x86-2015-1.0.98.0.exe" from http

[sqlite] System.Data.SQLite preRelease branch

Steffen Mangold wrote: > > Until final release I want to download the preRelease [e670692d90] > created for 18 days. > Normally, the "preRelease" branches are just a staging area for changes needed during the release process. If packages are available for a pre-release build, there will be a "Pr

[sqlite] System.Data.SQLite encryption

Anyone know which encryption algorithm is used in System.Data.SQLite? Seems like it doesn?t use the standard SEE sqlite extension. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] System.Data.SQLite encryption

On Thu, Aug 6, 2015 at 4:16 AM, Marco Bambini wrote: > Anyone know which encryption algorithm is used in System.Data.SQLite? > Seems like it doesn?t use the standard SEE sqlite extension. > https://www.mail-archive.com/sqlite-users at sqlite.org/msg87770.html -- -- -- --???--

[sqlite] System.Data.SQLite 1.0.97 on Win10

On 24 Jul 2015, at 9:05am, Jan Leimbach wrote: > I created a simple test statement like UPDATE tablename SET field = '123' > WHERE field = '321' > It returns always "Not an error" and does not update the table. It's like your Mum told you to finish empty all bins but they were already empty.

[sqlite] System.Data.SQLite 1.0.97 on Win10

Hi everyone, I try to update a table in my sqlite database and get "Not an error" result from the SQLite engine. The same query works on win7. I know that win10 is not final released yet, but I have no clue wants going wrong here. I created a simple test statement like UPDATE tablename SET field

[sqlite] System.Data.SQLite version 1.0.97.0 released

System.Data.SQLite version 1.0.97.0 (with SQLite 3.8.10.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQ

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

es at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe Mistachkin Sent: Tuesday, May 12, 2015 8:43 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues Mike Nicolino

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

Hey Everyone, For reference I'm using version 1.0.95.0 of System.Data.SQLite. I've got System.Data.SQLite embedded in our cloud web service using virtual table modules to access our various data sources. Our IIS is configured to abort requests that exceed a maximum time threshold (required for

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

Mike Nicolino wrote: > > The issue is isolated to ThreadAbortException since you can't catch it and > prevent it from being re-thrown. I did find a 'fix' for a similar issue > in SystemData.SQLite back on 10/11/2012: > Thanks for the excellent analysis of the issue. I believe you are completely

[sqlite] System.Data.SQLite, Need alternate way to get field length

gt; users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Saturday, May 02, 2015 3:11 PM > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] System.Data.SQLite, Need alternate way to get > field length > > William Drago wrote: > > I

[sqlite] System.Data.SQLite, Need alternate way to get field length

William Drago wrote: > I am trying to determine the number of bytes in a blob. According to the help > file under SQLiteDataReader.GetBytes Method in the Remarks section: > > "To determine the number of bytes in the column, pass a null value for the > buffer. The total length will be returned." >

[sqlite] System.Data.SQLite, Need alternate way to get field length

All, I am trying to determine the number of bytes in a blob. According to the help file under SQLiteDataReader.GetBytes Method in the Remarks section: "To determine the number of bytes in the column, pass a null value for the buffer. The total length will be returned." I'm working in VEE and

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with a sqlite database file

0700 From: "Joe Mistachkin" To: "'General Discussion of SQLite Database'" Subject: Re: [sqlite] System.Data.Sqlite with EF6 and VS2013 not working with asqlite database file Message-ID: <16CD11762DDC441E9DAFF33904AE7DC7 at LACHRYMOSE> Content-Type

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with asqlite database file

Jingfei Hu wrote: > > I have a VS2010 project from one of my friends. The project contains a > sqlite3 database file containing some tables and some views. According to my > friend, the database file is working properly with Visual Studio 2010 at > that time. Also I can see the edmx file and gene

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with a sqlite database file

Hi team, My dev box is: 1. Windows 8.1, 64 bit 2. Visual Studio 2013 with update 4 I've got a problem like this: I have a VS2010 project from one of my friends. The project contains a sqlite3 database file containing some tables and some views. According to my friend, the databas

[sqlite] System.Data.SQLite and spellfix under VB.net

: Donnerstag, 12. M?rz 2015 19:17 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net The zip should contain 4 files shell.c sqlite3.c sqlite3.h sqlite3ext.h sqlite-amalgamation-3080803.zip -Urspr?ngliche Nachricht- Vo

[sqlite] System.Data.SQLite and spellfix under VB.net

o:sqlite-users- >bounces at mailinglists.sqlite.org] On Behalf Of sonypsx >Sent: Thursday, 12 March, 2015 11:56 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] System.Data.SQLite and spellfix under VB.net > >Hello, > >may i ask again ... >Can somebody help t

[sqlite] System.Data.SQLite and spellfix under VB.net

Gesendet: Mittwoch, 04. M?rz 2015 19:54 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net Hello Joe, ok i'll tried: gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c and got this error: c:\MinGW\bi

[sqlite] System.Data.SQLite and spellfix under VB.net

bounces at mailinglists.sqlite.org] Im Auftrag von sonypsx Gesendet: Mittwoch, 04. M?rz 2015 19:54 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net Hello Joe, ok i'll tried: gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfi

[sqlite] System.Data.SQLite and spellfix under VB.net

det: Montag, 02. M?rz 2015 22:37 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The

[sqlite] System.Data.SQLite version 1.0.96.0 released

System.Data.SQLite version 1.0.96.0 (with SQLite 3.8.8.3) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQL

[sqlite] System.Data.SQLite and spellfix under VB.net

Hello, May I post this question again - since I did not got any reply. could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here: http://www.sqlite.o

[sqlite] System.Data.SQLite and spellfix under VB.net

sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The first step would be to compile the spellfix extension as a loadable module, as documented here: https://www.sqlite.org/loadext.html Next, you can load it usin

[sqlite] System.Data.SQLite version 1.0.95.0 released

System.Data.SQLite version 1.0.95.0 (with SQLite 3.8.8.3) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQL

[sqlite] System.Data.SQLite and spellfix under VB.net

Hello, could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here: http://www.sqlite.org/spellfix1.html I end up with an error: "SQL logic error or missing database no such module: spellfix1" I'm

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

OK. Embarassing as it is, I'm going to have to 'fess up here. When I attempted to implement a stopwatch which wasn't available, I discovered that the app was targetting .Net 2. When I rebuilt it targetting 3.5 it worked. Unfortunately the stopwatch tells me that it takes longer than I would like (

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > I'm not using the Spatialite extension for the query, only the indexes > created by it on the desktop which I think is a pretty standard SQLite > RTree. At least it works that way on the desktop. > So, on the target device, only the System.Data.SQLite binaries are being us

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

> Thanks. I've run the schema and query here with the desktop version of > SpatiaLite and it does not crash. I suspect the underlying issue may be > an alignment fault (or stack overflow) due to bad interaction between the > ARM processor architecture and the SpatiaLite extension. I'm not using

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > The db was created by Spatialite and has a fairly lengthy schema. I'm not > sure if I should leave anything out so I'll attach a text file. > Thanks. I've run the schema and query here with the desktop version of SpatiaLite and it does not crash. I suspect the underlying

  1   2   3   4   5   >