Re: [sqlite] Bug in SQLite version 3.31.1 and 3.32?

I just want to point something out that might help the original poster. On Saturday, March 7, 2020, 7:00:21 AM EST, sqlite-users-requ...@mailinglists.sqlite.org wrote: > > 1.  NULL is NULL = Yes, True, > 2.  NULL is FALSE = Nope, False. > 3.  NULL is TRUE  = Nope, False. > 4.  NULL is

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

ram wrote: > > Hi Joe, > > Do you have an ETA on the new build? > > Also I wanted to confirm the change to the variable that would allow me to > set the number of attachments to a number higher than 10. I would like to set > it to 25. > > Keith > > -Ori

Re: [sqlite] Possible caching issue between connections with specific inserts

Alexey Podogov wrote: > > Also, the issue can't be reproduced if: > - Cache size is set to 0; or > - Journal mode is WAL; or > - Password for database is too short (please see examples in the > demo code). > Thanks for the report. I'm looking into it no

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram wrote: > > Do you have an estimated time for this release? > If everything goes as planned, right around the third week of February. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

I’ll raise the default limit for the next release of System.Data.SQLite. Sent from my iPhone > On Jan 16, 2020, at 2:01 PM, Keith Bertram wrote: > > Yes I recognize that this would be a problem. I plan on having no more than > 20-25 attachments. > > If I understand correctly, the only way

Re: [sqlite] Question about passwords in System.Data.Sqlite

Lite on .NET Core for all supported platforms. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about passwords in System.Data.Sqlite

Which encryption extension are you using? Sent from my iPhone > On Jan 2, 2020, at 5:48 PM, Mike King wrote: > > Hi, > > This is my third attempt to send the following message to the list and each > time it gets rejected as suspected administrivia! (not sure what that is - > I guess it's a

Re: [sqlite] System.Data.SQLite.Core and Core-Linux version Mismatch [nuget]

There doesn’t appear to be a NuGet package named “System.Data.SQLite.Core-Linux” that I can see. I don’t fully understand what the issue is here; however, in general, all versions must match up. Also, the System.Data.SQLite.Core package should contain a native binary usable on Linux x64.

Re: [sqlite] Entity Framework Core support

ng effort and a lot more like a rewriting effort. That does not necessarily mean it won't get done (at some point); however, that will certainly impact it's relative priority on the roadmap. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] Deployment question

ework" setting for the project(s) on the "Application" tab within their project properties. For the set of DLLs from the new download, you'll want to make sure they are all set to .NET Framework 4.6. -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Entity Framework Core support

Given that Entity Framework 6.3.0 was released quite recently (with .NET Core support), it seems that it should be around for a while longer. Currently, there are no specific plans to support Entity Framework Core in System.Data.SQLite. -- Joe Mistachkin

Re: [sqlite] Deployment question

ds/1.0.112.0/sqlite-netFx46-static-bin ary-app-2015-1.0.112.0.zip -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Deployment question

System.data.sqlite. > When you say "installed", do you mean to say that you obtained the files from one of the "Setup" packages on the download page? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.112.0 released

on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Yes, the NuGet packages are included in the release. Sent from my iPhone > On Oct 24, 2019, at 9:13 AM, Keith Bertram wrote: > > Ok. Thanks. Does it get immediately placed under nuget? > > Keith > > -Original Message- > From: sqlite-users On Behalf &g

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Within the next week or so. Sent from my iPhone > On Oct 24, 2019, at 8:37 AM, Keith Bertram wrote: > > Ok. Thanks. Do you have an estimated release date? > > Keith > > -Original Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: We

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

but I don't see a matching way to do this within System.Data.SQLite.dll. > Thanks for pointing this out. I'll make sure that some way to accomplish this ends up in the 1.0.112.0 release, which is due out shortly. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] System.Data.SQLite.EF6 feature request: Timespan support

I’ll look into adding this type mapping to System.Data.SQLite. Sent from my iPhone > On Aug 19, 2019, at 7:19 PM, Barry wrote: > > A project I work on runs mainly on SQL Server, but there are times we want > to be able to create the same data model in SQLite for portability. > > We mostly

Re: [sqlite] System.Data.SQLite.dll.config in final build

vior before. Are you manually customizing the MSBuild files for the project? > > It has a note in it: do not copy this file to any of the build output > directories > Generally, it's not supposed to be in those directories. Is it causing any issues when loading the native SQLite int

Re: [sqlite] using System.Data.SQLite on Linux / ".Net Core 2"

Yes. Currently, there are binaries that support Windows, Linux, and MacOS in the “System.Data.SQLite.Core” NuGet package: https://www.nuget.org/packages/System.Data.SQLite.Core Sent from my iPhone > On Jul 21, 2019, at 1:27 PM, Larry Brasfield > wrote: > > Is there a build of

Re: [sqlite] Exception in SQLite.dll (1.0.111.0)

ta.SQLite on more than one thread? Further, are you making sure that all objects that belong to a connection opened on a given thread X are not references on any other threads at the same time (including SQLiteCommand, SQLiteDataReader, et al)? -- Joe Mistachkin ___

[sqlite] System.Data.SQLite version 1.0.111.0 released

on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

LL build.bat ReleaseManagedOnly -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

et of MSBuild properties and then customize the source code for "SQLite.Interop.dll", e.g. in the "interp.c" source code file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

is what it says: > In order to do this, you'll want to execute the PRAGMA statements against the connections that you open prior to running other SQL. The flags for the connection (primarily) control the behavior of System.Data.SQLite and they (generally) have no relation to PRAGMA statements.

Re: [sqlite] Odd exception when creating a connection object

able to compile a build of System.Data.SQLite locally? On trunk, I've added the ability to disable the SQLiteLog subsystem using a new environment variable ('No_SQLiteLog'). Are you able to test the effects of this enhancement in your environment? --

Re: [sqlite] Odd exception when creating a connection object

ative API while the connections are being created? Any details you could provide in order to reproduce this could be useful. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/m

Re: [sqlite] What is the most commonly used file extension for sqlite3 database files?

Am 23.03.2019 um 17:06 schrieb Peng Yu: Hi, I see a variety of extensions for sqlite3 database files, such as .db, .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted convention for the extension? Thanks. In the DatenBurg Environment, "*.sqlite" is used.

[sqlite] System.Data.SQLite version 1.0.110.0 released

on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.110.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, February 22nd. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Support for System.Data.SQLite: Different API type for int/integer columns

4-bit integer, mostly for reasons of backward compatibility. In order to customize the mappings, the flag UseConnectionTypes should be used when opening the connection -AND- the AddTypeMapping method is used to override a built-in mapping of the same name (e.g. "

[sqlite] Documentation error

est: If the documentation is wrong, update it to say .indices instead of .indexes. or Request: If the documentation is accurate, update the docs with a note that older versions of sqlite referred to the .indexes command as .indices thanks, Joe Jacobs ___ sql

Re: [sqlite] Problem using System.data.SQLite

dress deployment these issues in a portable (and supported) way. It appears that I may need to figure out a way to automatically update the JSON file associated with the application, but that does not seem like the most elegant solution. -- Joe Mistachkin ___

[sqlite] How to find records in a table which are not in a second table?

in the nam values of table B? Thanks --  Joe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Next release

Roger Schlueter wrote: > > What about System.Data.SQLite? > I would estimate that the next System.Data.SQLite release, which will include SQLite 3.25, will be released within two to three weeks after SQLite 3.25 itself is released, barring an unforeseen complications. -- Joe M

[sqlite] System.Data.SQLite version 1.0.109.0 released

features full support for .NET Core v2.0 on Windows, macOS, and Linux. The .NET Framework v4.7.2 and Mono v5.12 are also supported. Please post on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

olved; however, in the past, these types of issues have been caused > > by a mismatch between how the .NET Framework and SQLite treat typing > > of column values and/or a mismatch between the data type used in the > > query and the one actually stored in the database file. >

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

e one actually stored in the database file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Different behavior of .NET client 1.0.108.0SQLiteDataAdapter / DataReader on literal int values in select list.

;1 > Since no rows are returend, there is no type information available based on the value of the returned data (as there is no data). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] Need a document/link or suggestion

to "sqlite3" (for Windows) or "libsqlite3" (for other operating systems). This should allow the Mono and/or .NET to find it. I assume it will need to be located in the same directory as the managed "SQLite-net-pcl" assemblies. -- Joe Mistachkin ___

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

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.109.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to next Monday, June 4th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

[sqlite] System.Data.SQLite version 1.0.108.0 released

on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

Re: [sqlite] not able to save log to sqlite

the connection string must use "Data Source", with a space between the words. I'm not sure if the space is be preserved in your config file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.108.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this Wednesday, February 28th. Thanks. -- Joe Mistachkin ___ sqlite-users ma

Re: [sqlite] Using Sqlite nuget package in a .Net test assembly

Greg Pagendam-Turner wrote: > > Using Sqlite nugget package version 3.13 > Are you using the full (desktop) .NET Framework? If so, the NuGet package you probably want is probably "System.Data.SQLite". -- Joe Mistachkin ___ sqlite

Re: [sqlite] invalid date time

requested value into the declared type (which I assume is DateTime in this case). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.107.0 released

on the SQLite mailing list (sqlite-users at mailinglists.sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] SQLite 3.22.0: Precompiled Windows 64-bit DLL is 32-bit?

Stanley Jacob wrote: > > With 3.22.0, this produces "ImportError: DLL load failed: %1 is not a > valid Win32 application." > With 3.21.0, there is no error. > Thanks for the report. It should be the x64 version now. -- Joe Mistachkin _

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.107.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, January 26th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Compilation failure for sqlite3_analyzer

link the "compat\tcl" directory within the source tree to the "C:\Tcl" directory (via an NTFS junction): CD /D C:\path\to\sqlite\compat MKLINK /J tcl C:\Tcl -- Joe Mistachkin __

Re: [sqlite] An issue with System.Data.SQLite

Aleksey Lulchenko wrote: > > Please, give me the clues what is going wrong, if you can. I think it > is a typical bug in many situations. > Could you please show us the schema of the table (or tables) involved? -- Joe Mistachkin ___

Re: [sqlite] Cross-compiling fails.

er NMAKE macros like USE_NATIVE_LIBPATHS, NCRTLIBPATH, and NSDKLIBPATH. For example, nmake /f Makefile.msc sqlite3.exe XCOMPILE=1 USE_NATIVE_LIBPATHS=1 Alternatively, you can build the amalgamation source code file "sqlite3.c" without cross-compiling and then cross-compile it.

Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows)

Simon Slavin wrote: > > I'm hoping that Joe Mistachkin, or someone else who understands > that library sees this, just to check that it works the way > you're expecting it to. > Judging from the description so far, I think that both SQLite and System.Data.SQLite are wo

Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows)

inal poster may wish to increase the default retry values using the SQLITE_FCNTL_WIN32_AV_RETRY file control with the sqlite3_file_control() function, see: https://www.sqlite.org/c3ref/c_fcntl_begin_atomic_write.html -- Joe Mistachkin @ https://urn.

[sqlite] System.Data.SQLite version 1.0.106.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

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

s upcoming release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with these pre-release packages. -- Joe Mistachkin @ https://urn.to/r/

Re: [sqlite] TR: Database base disk is malformed issue

got a Database base disk is malformed issue. We > can repair the base via an sql dump of the base. The issue itself is never > exactly the same : we can have a duplicate  TRIGGER or TABLE or sometimes > INSERT INTO with non valide data. > Are you able to share the full schema for the d

Re: [sqlite] Join, Union, Subquery or what?

in Katalog that doesn't have a corresponding date in ZKatalog. Cheers, Ryan On 2017/09/06 1:09 PM, Clemens Ladisch wrote: Joe wrote: my SQLite database has two tables Katalog and ZKatalog with the same structure. One of the columns  is called DDatum. What's the most efficient way to (1

[sqlite] Join, Union, Subquery or what?

) Select records, which are with same column values except DDatum in Katalog and in ZKatalog? (4) Select records from Katalog and ZKatalog with same DDatum content? Thanx --  Joe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

[sqlite] System.Data.SQLite version 1.0.105.2 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Another note: The GUID column will need to be marked as UNIQUE or PRIMARY KEY in the CREATE TABLE statement in order for the BLOB lookup to work properly. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Sergio Capozzi wrote: > > It seems the KeyInfo calculation is doing something wrong. > Is there a workaround or is a known bug? > Version 1.0.105.1 > Thanks for the report. This should now be fixed on trunk. -- Joe Mistachkin @ https://urn.

Re: [sqlite] Memory Issue - GLOBs and Windows Active Mapped File

Have you tried using the command "PRAGMA mmap_size=0;" on the connection? https://www.sqlite.org/pragma.html#pragma_mmap_size -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.

[sqlite] System.Data.SQLite version 1.0.105.1 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] Bug causing MSVC to fail to compile Session Extension from the amalgamation

this and fails the > compilation. > Thanks for the report. This should now be fixed on trunk. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

[sqlite] System.Data.SQLite version 1.0.105.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] Selecting from view with System.Data.SQLite throws

What is the declared data type for the column? Also, what are the raw values for the first row? You may want to use the SQLite command line tool to query the database for them. Sent from my iPhone https://urn.to/r/mistachkin > On Apr 8, 2017, at 12:55 PM, Joseph L. Casale

Re: [sqlite] Visual Studio 2015 Express C# LoadExtension() not working?

I can think of one possibility offhand: The application is running as 32-bit and the extension DLL is 64-bit (or vice-versa). Sent from my iPhone https://urn.to/r/mistachkin > On Mar 17, 2017, at 5:02 PM, Phil Pollock wrote: > > I can't get the LoadExtension()

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

a fairly reasonable value. Alternatively, it can be overridden at compile-time. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listin

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

ACHE_SIZE and/or SQLITE_DEFAULT_PAGE_SIZE defines. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

_SIZE. > What values are you using for the SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_PAGE_SIZE defines? -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

on: "Specified cast is not valid." > Changing the type of iKeyID to "long" should make it work, e.g.: long iKeyID = (long)sqliteCmd.ExecuteScalar(); Alternatively, you should also be able to use the LastInsertRowId property of the SQLiteConnection object, e.g.:

Re: [sqlite] SQLite3 Pros / Cons

3.dll" by the P/Invoke integration). -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

ter", "SQLiteCommand", "SQLiteConnection", "SQLiteDataReader", etc. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

//urn.to/r/sds_docs The primary classes you'll want to look into include SQLiteConnection, SQLiteCommand, SQLiteParameter, and SQLiteDataReader. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailingli

[sqlite] View column data type affinity?

Is there a way when creating a view to specify the data type affinity for each column? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.104.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.104.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, December 12th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Parallel access to read only in memory database

_open*() C APIs? Further details on using URI file names may be found here: https://www.sqlite.org/uri.html -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.s

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

" for Linux, Mac OS X, and probably other POSIX compliant systems, using the following build script: https://urn.to/r/7C -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.103.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.103.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, August 29th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

re supported on a "best effort" basis, mostly because: 1. They were never fully completed. 2. The Visual Studio extensibility interfaces they use are very fragile and scarcely documented. 3. Debugging them is nefariously difficult. -- Joe Mistach

Re: [sqlite] Failed to install Microsoft Visual C++ Runtime

must (?) be (at least) one that is new (to Visual Studio 2015). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SqliteDataAdapter fill wrong data when select data from database

When I use sqlite ado.net, I met a bug made me confused. My table schema and data is like this. Table name is "a". IDTEXT DOUBLE 1 AA 1 2 BB 1.2 3 CC 2 When I run SQL statement("select * from a"); I got double column's data is 1 1 2, and column dataType is

Re: [sqlite] UNIQUE constraint violation

corrupted index, whereas the one I had used did not? Does it mean that your query doesn't use the index? Joe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UNIQUE constraint violation

US OFF, but will now have NORMAL. Joe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UNIQUE constraint violation

On 6/28/2016 4:52 PM, Simon Slavin wrote: On 28 Jun 2016, at 11:22pm, Joe Pasquariello <j...@fenway.com> wrote: select rowid, device, hex(device), localtime, udatetime from eventlog where device like '%M14' and udatetime=1415000934 rowiddevicehex(device)localtimeuda

Re: [sqlite] UNIQUE constraint violation

On 6/28/2016 3:05 PM, Simon Slavin wrote: SELECT device,HEX(device) FROM myTable WHERE Thanks, Simon. Now it's getting really strange. Two queries and their results are shown below. The value of "device" seems to be the same in both rows. One query includes the field "localtime" and the

Re: [sqlite] UNIQUE constraint violation

14150009342456964.825625 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Joe Pasquariello Fenway Systems, LLC 2980 College Ave, Suite 7 Berkeley, CA 947

[sqlite] UNIQUE constraint violation

device,localtime,code,type,text,0 as status, count(*) as the_count from eventlog group by udatetime,device,code,type,status having count(*) > 1 > On 2016/06/28 9:37 PM, Joe Pasquariello wrote: > Hello, > > I'm a novice user of Sqlite, and could use some help. The code below &g

[sqlite] UNIQUE constraint violation

uld cause the violation? Thanks, Joe BEGIN TRANSACTION; DROP TABLE IF EXISTS TempEventLog; ALTER TABLE EventLog RENAME TO TempEventLog; CREATE TABLE IF NOT EXISTS EventLog( rowid INTEGER PRIMARY KEY, udatetime INTEGERNOT NULL, deviceCHAR(16) NOT NULL COLL

[sqlite] System.Data.SQLite version 1.0.102.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

1.0.102.0 for this. I'll look into it for 1.0.103.0. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.102.0 have begun...

Eric Sink wrote: > > The next time April 15th falls on a Friday is 2022, so I guess we have plenty > of time. > Actually, it did say Monday, June 20th before I sent it; however, my mail client is apparently acting up. -- Joe Mistachkin __

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.102.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, April 15th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] Can't find PInvoke DLL 'SQLite.Interop.101.dll'.

Nigel Walton wrote: > > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > PID:01FD0185 TID:057E0022 testce.EXE > MissingMethodException > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > Do you have the appropriate MSVC runtime ("MSVCR110.DLL") i

Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

must be set to "incremental" first, per: https://www.sqlite.org/pragma.html#pragma_incremental_vacuum -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite built as Multithread

e used with native SQLite libraries that need to work with System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   4   5   6   7   8   9   10   >