Re: [sqlite] About Sqlite for Windowsphone

between these project types; however, I think the SQLite Extension SDK should be usable from both, as long as the one targeting Windows Phone 8.1 is chosen. Microsoft may be able to provide more specific answers on developing for Windows Phone 8.0 and 8.1 with Visual Stud

Re: [sqlite] About Sqlite for Windowsphone

er, if they downloaded manually and then installed they should work fine. This is NOT an issue with SQLite itself, nor with its associated VSIX packages. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cg

Re: [sqlite] About Sqlite for Windowsphone

ps://github.com/peterhuene/sqlite-net-wp8 I'm not sure if the above managed wrapper works on Windows Phone 8.1 yet. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3; > Is the above query the one that has the issue? What is the output you expect from it? --

Re: [sqlite] System.Data.Sqlite

o reproduce your results here. Could you please provide the list of all SQL statements used to get the database into the state where the issue is seen, including any INSERT statements used to populate it with the test data. -- Joe Mistachkin ___ sqlite-u

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > > Here is the list of all sql statements in the file Base.sql, included > INSERT Statements. > Unfortunately, the mailing list strips most attachments. Can you include the information within the message itself? -- Jo

Re: [sqlite] Need help on SQLite In-Memory Mode

Try this: SQLiteConnection connection = new SQLiteConnection( "FullUri=file::memory:?cache=shared;"); -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailma

Re: [sqlite] The SQLite Download Files For Visual Studio 13 are not .visx files

dialog, you can select "Visual Studio Gallery" within the "Online" option and then enter "SQLite" in the search box at the upper-right corner of the dialog. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

" = 87) ORDER BY "Country"."Title" ASC; } parray rows The above uses the EagleShell from the Externals directory in the source tree. Here, the final line of output from the above script is: rows(names) = Id Code Title ShortTitle ModifiedOn ModifiedBy Underneath, this ends

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

der class is a very thin wrapper around the underlying sqlite3_column_name() API. Basically, it just returns whatever the sqlite3_column_name() API returns verbatim. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

above view refers to other tables as well. Anyhow, the best I can come up with at this point is that the ORM package(s) really should include AS clauses in the generated SQL in order to get the desired column names, per the SQL standard. This is not a bug in SQLite

Re: [sqlite] Win32 .def exports != documented APIs ?

ed alternative is to use the associated PRAGMAs (e.g. "data_store_directory" and/or "temp_store_directory") against a temporary in-memory database prior to opening another database. -- Joe Mistachkin ___ sqlite-users mailing list sq

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.94.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, September 8th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] System.Data.SQLite - issues

Chris Abbott wrote: > > I've also noticed a drastic degradation in speed with this release over > 1.0.86. > This issue should be fixed in 1.0.94.0. Please try with the pre-release bits available at: https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.

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

riday, September 12th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reinstalling My Build Environment

it run. > We want to help you. When you say "have it run", are you talking about the design-time support for EF6 or actual compiled .NET applications using the System.Data.SQLite runtime assemblies? Unfortunately, getting the design-time components to work correctly with 5 differen

Re: [sqlite] Reinstalling My Build Environment

I assume that you did not see the response I sent earlier? http://www.mail-archive.com/sqlite-users%40sqlite.org/msg85999.html -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] System.Data.Sqlite.dll v93 performance issues...

e in your environment. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite Development Team support of System.Data.SQLite (was RE: Reinstalling My Build Environment)

rted and *IS* maintained by the SQLite Development Team. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reinstalling My Build Environment

link) and the download page (link below) are both good places for people to look. https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

[sqlite] System.Data.SQLite version 1.0.94.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@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

s should also setup the appropriate entries in the "App.config" file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Missing SQLite.Designer.SQLiteDataViewSupport?

ile > time, or that all the satellite assemblies required are loadable and fully > signed." > I'm pretty sure this issue was fixed quite a while ago. The 1.0.84.0 release is from January 2013. Please upgrade to the 1.0.94.0 release and let us

Re: [sqlite] Unable to open database file

slashes are now required), e.g.: // // NOTE: The C# compiler itself needs the backslashes escaped // as well, hence there are 8. // string fileName = "server\\share\\path\\to\\database.db&

Re: [sqlite] Missing SQLite.Designer.SQLiteDataViewSupport?

ny other additional information you could provide would be useful as well. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.74.0 released

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

Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

ds or just the underlying database connection? The SQLiteDataReader class is not thread-safe and should not be shared between threads. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

I do not see anything obviously wrong with using the same connection to construct two or more LINQ data contexts; however, my knowledge of LINQ and its use of threads is somewhat limited. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users

Re: [sqlite] System.Data.SQLite Reserved Words Bug

he project file "SQLite.Interop.2010.vcxproj" is incorrect: $(IntDir)System.Data.SQLite.%(Filename).resources It should read: System.Data.SQLite.%(Filename).resources This issue has been fixed in: http://system.data.sqlite.org/index.html/ci/55f56ce508 Th

Re: [sqlite] Sqlite .net problem error175 in Visual studio 2010

ngs; however, it might be best to temporarily use the legacy version of the System.Data.SQLite assembly if you require the VS designer components (if the VS2010 SP1 issue can be figured out). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handle leak using IIS on windows 7?

. This existing instance of the DbLogger class no longer has a valid connection because it was previously closed (and set to null). 6. Newly created commands will not have a valid connection. 7. Attempting to execute a command without a valid connection will result in the exception you are seeing. -- Joe

Re: [sqlite] Cannot add interop assembly

"System.Data.SQLite" assembly instead. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot add interop assembly

> Isn't it odd that I cannot just add it as a ref? > No, it's not odd, it's a pure native DLL. Adding a reference requires the DLL to be a managed assembly. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite problem

ame application on 32-bit Windows, it will run as a 32-bit process. A 64-bit process cannot load a 32-bit DLL. Therefore, the "test.exe" program starts as a 64-bit process and then attempts to load the 32-bit "SQLite.Interop.dll", which raises the BadImageFormatException. -

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

FoundException: SQLite.Interop.DLL. > I seem to recall that the LD_LIBRARY_PATH may need to be modified to actually look in the bin folder for the application? I could be wrong here because I am not an expert on Mono. -- Joe Mistachkin ___ s

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

ell.com/show_bug.cgi?id=636915 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Difference between Setups and Precompiled binaries forwindows

fficult to say as it depends on the what your use cases are. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite.xml -- documentation for the wrongassembly

t;testlinq" assembly while the > actual documentation for "System.Data.SQLite" is missing. > This issue was recently fixed (Aug 9th) and will be included in the 1.0.75.0 packages when they are released. For details of the fix, see check-in: http://system.data.sqlite.org/inde

Re: [sqlite] System.Data.SQLite Release

> > Just wondering when the next release of System.Data.SQLite will be > available. > My current plan is to produce a release before the 15th of September. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] System.Data.SQLite execute query without using of indexes

, reader[0]); } } finally { reader.Close(); } Please note that even the above code will show some overhead associated with using SQLite from managed code; however, it will be less than the original code. -- Joe Mistachkin ___ sq

Re: [sqlite] TransactionScope ON CONFLICT

in Fossil. If you need information on checking out or building the System.Data.SQLite source code, please let me know and I will send complete step-by-step instructions. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TransactionScope ON CONFLICT

ll the binaries should be in the following directory: C:\dev\sqlite\dotnet\bin\2010\Release\bin 12. Copy the "SQLite.Interop.dll", "System.Data.SQLite.dll", and "System.Data.SQLite.Linq.dll" files into your application directory. -- Joe Mistachkin

Re: [sqlite] TransactionScope ON CONFLICT (oops, missed a step)...

\Release\bin 14. Copy the "SQLite.Interop.dll", "System.Data.SQLite.dll", and "System.Data.SQLite.Linq.dll" files into your application directory. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] TransactionScope ON CONFLICT

ng any error will be added to the database. Any rows that fail constraints will not be added. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TransactionScope ON CONFLICT

ed. The test case verifies that all 10 rows that should be added are in fact added. It also verifies that the appropriate exception is raised for the PRIMARY KEY constraint violation. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] TransactionScope ON CONFLICT

ctionScope transaction = new TransactionScope()) { context.Connection.Open(); // try adding this line. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error while using provider to import into SQL Server

The issue you are seeing is detailed here: http://www.mail-archive.com/sqlite-users@sqlite.org/msg62336.html It has already been fixed in the source tree and the fix will be in the next release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] Compiling managed-only System.Data.SQLite version 1.0.74.0with MonoDevelop

rivial complexity. For now, MSBuild and Visual Studio are the only fully supported build environments. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

wise, you'll simply get a BadImageFormatException when the managed process (which will actually start as a 64-bit process) tries to load a 32-bit SQLite.Interop.dll. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 the currentversion?

technically 1.0.75.0 beta. The NuGet package is not necessarily going to be the 'preferred' way of distributing the bits in the future; however, it will be one way to get them. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 thecurrentversion?

Wamiduku wrote: > > Are there any plans to also provide the stable version as a NuGet package? > Yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

.cs:line 131 > Please make sure the necessary ICU DLLs are located in the same directory as the SQLite.Interop.dll OR somewhere along your PATH and the problem should go away. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

Your list does not seem to include the ICU DLLs that I mentioned, including: icuuc48.dll icuin48.dll The necessary ICU files can be obtained from the official web site: http://site.icu-project.org/ -- Joe Mistachkin ___ sqlite-users mailing list

[sqlite] System.Data.SQLite version 1.0.75.0 released

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

[sqlite] System.Data.SQLite version 1.0.76.0 released

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

Re: [sqlite] Problems building/running SQLite test.exe withICU enabled

ssage you are seeing. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] issue loading SQLite.Interop.dll in different folder

llow the guidelines outlined in the above linked MSDN documentation. However, using the bundled version may be a lot easier in your case, especially since you already have separate directories for 32-bit and 64-bit. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Sqlite WPF application (designer view) toolbox greyed out

F project in C# or VB.NET code. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite Exception with wrong password

error code returned from the native core SQLite library. In the case you mention, the exception is technically correct even though it may seem counterintuitive at first glance. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

thing that the installation does, which the uninstall > doesn't undo, that you have to do in order to get System.Data.SQLite > working. The question is what, and how can you do it without having to > run the installation? > The setup attempts to undo everything that it does, including t

Re: [sqlite] System.Data.SQLite won't work untill Iinstall+uninstallit.

will be present in the: \bin\\\Static directory, where year is 2008 or 2010, platform is Win32 or x64, and config is Release or Debug. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ChangePassword method problem

ll the SetPassword method on that connection object (or supply the password as plain-text in the connection string)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ChangePassword method problem

nreadable using the updated or previous password. > I've added some more unit tests to the test suite to verify that this feature works as documented and I'm not seeing any issues. Could you post some simplified C# code that demonstrates the behavior you are seeing?

Re: [sqlite] ChangePassword method problem

One thing that could be a potential issue here is that all connections must be closed prior to changing the password on the database [except the connection used for the ChangePassword method call itself]. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] ChangePassword method problem

Farhan Husain wrote: > > Aah, ok. So, for all the methods that act on the database I should explicitly add > conn.Close() within the using conn scope? > Well, I'm not familiar with your specific project; however, that does not sound like a bad idea. -- Jo

Re: [sqlite] Using SQLite on Windows 64bit

, which contains both the native and managed code required for using SQLite (i.e. it is more suitable for GAC'ing without having to alter the system PATH, etc). -- Joe Mistachkin <j...@mistachkin.com> ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Using SQLite on Windows 64bit

omer does not. > > How do I get the interop? > With the "bundle" packages, you do not need it because the native SQLite code is compiled into the System.Data.SQLite.dll assembly itself. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] ChangePassword method problem

Reading your code quickly, it seems the problem may be related to the use of single-quotes (') around the passwords in the connection string. Please remove all the single-quotes and try again. -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] newer SQLite

's near the bottom of the download page): https://system.data.sqlite.org/sqlite-netFx35-binary-PocketPC-2008-1.0.76.0. zip -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Followup: Added Missing error message to past post.

taining the pre-compiled binaries you need. In your case, it sounds like you will want to download the x86 mixed-mode assembly compiled statically against the .NET Framework 3.5, available here: https://system.data.sqlite.org/sqlite-netFx35-static-binary-bundle-W

[sqlite] System.Data.SQLite version 1.0.77.0 released

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

Re: [sqlite] ADO provider for net 2.0/3.5.

Studio designer components) as part of build 78 (i.e. the next release). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Managed only / Mono and Linux support

or 2010 if you want .NET 4.0. 3. Change the current directory to the root of the System.Data.SQLite source code tree. 4. Execute the following command, where [year] is either 2008 or 2010: MSBuild.exe System.Data.SQLite\System.Data.SQLite.[year].csproj /t:Rebuild /p:Configuration=R

Re: [sqlite] ADO provider for net 2.0/3.5

wrong place. Is > it possible that you could forward me the files? > The source code is here: https://system.data.sqlite.org/index.html/finfo?name=tools/install/Installer .cs It is also included in the released source code archive; however, the b

Re: [sqlite] Managed only / Mono and Linux support

Yves Goergen wrote: > > So, where could I have found that information if not here? > Good point, I'll add that command line to the "Build Procedures" page on the web site. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-us

Re: [sqlite] import CSV in ADO.NET

ou could execute the sqlite3.exe file as an external process, passing it the necessary arguments. For more information on the shell, please see: http://www.sqlite.org/sqlite.html -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Load a .NET DLL with additional functions usingload_extension

H K wrote: > > Is it possible to load these functions with the load_extension function? > Please take a look at the SQLiteFunction help topic in the System.Data.SQLite CHM file, here: http://system.data.sqlite.org/index.html/artifact?filename=Doc/SQLite.NET.ch m=tip -- Joe M

Re: [sqlite] FW: SQLite with Vis. Studio C# Entity Framework 4.1

contains the same managed code; however, the contained SQLite core native code has been compiled for x64. https://nuget.org/packages/System.Data.SQLite.MSIL Finally, the last one (above) contains ONLY the managed code and must be used in conjunction with a "SQLite.Interop.dll" for the

Re: [sqlite] SQLite with Vis. Studio C# Entity Framework 4.1

> > I think I want to download and get started. > Great. > > My direct e-mail is j...@xexam.net > CC'd on this message. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Load a .NET DLL with additional functionsusingload_extension

H K wrote: > > Sorry but the file has a content table but no contents. > Am I doing something wrong with the chm? > Thx > You may need to right-click the file in Windows Explorer, go to "Properties", and then click on "Unblock" in order to make i

Re: [sqlite] Hi All, How to use System.data.sqlite on both 32-bit and 64-bit system.

> > is there a dll can be used on both system? > Not really. Different native code is required for 32-bit and 64-bit processes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

[sqlite] System.Data.SQLite version 1.0.97.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

Your issue might be related to this: https://system.data.sqlite.org/index.html/tktview/4bbf851fa5b26c1ca74a However, it's difficult to determine without seeing the database and the SQL generated from the LINQ code. -- Joe Mistachkin

[sqlite] String.Substring Generates Error

Etienne Charland wrote: > > There is a bug with String.Substring generating SUBSTRING instead of > SUBSTR, which results in the SQL query failing. > Is there some C# example code (and an associated database schema) which demonstrates this issue? -- Joe Mistachkin

[sqlite] Query returns "stack overflow error"

Etienne Charland wrote: > > https://www.spiritualselftransformation.com/misc/LinqSQLiteError.txt > What LINQ query is responsible for generating this SQL? -- Joe Mistachkin

[sqlite] String.Substring Generates Error

index.html/info/52085afe231b9e3e -- Joe Mistachkin

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

property. You might want to experiment with setting this property to false (it defaults to true). -- Joe Mistachkin

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

Jim Morris wrote: > > Is there a graceful work around? > > > (3850) SQLITE_IOERR_LOCK > Are any of the underlying database files read-only? -- Joe Mistachkin

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

tree. 2. Using the defines -DSQLITE_FORCE_OS_TRACE=1 -DSQLITE_DEBUG_OS_TRACE=1 when compiling in other environments. -- Joe Mistachkin

[sqlite] Using |DataDirectory| in connection string (.NET with System.Data.SQLite)

lots of references online showing that it is indeed used, > but I haven't found how to extract the file path from it at runtime. > Currently, there is no easy way to do that using only publically accessible parts of System.Data.SQLite; however, this limitation will be addressed in the next release. -- Joe Mistachkin

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

haps the Entity Framework is using more than one connection? The Progress event is per-connection and will only fire for progress events related to its associated connection. -- Joe Mistachkin

[sqlite] Sqlite and we7 local time issue

ocalTime" branch, here: https://www.sqlite.org/src/timeline?r=winCeLocalTime Please let us know if this clears the issues seen in your WinCE build environment. -- Joe Mistachkin

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.100.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] System.Data.SQLite version 1.0.100.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.101.0 released

on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

tations, etc. To compile an interop DLL for Mono, please grab the source code, extract it, and then use the following script (or something like it): http://urn.to/r/kJ -- Joe Mistachkin

[sqlite] How to register System.Data.SQLite as a data source?

ta source for what? The .NET Framework itself? Visual Studio? The tool used by the official setup packages for this purpose is here: http://urn.to/r/r -- Joe Mistachkin

[sqlite] How to register System.Data.SQLite as a data source?

e. However, it would be required, with a value of "false", if you actually wanted to make changes to the system. -- Joe Mistachkin

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

s. The file names used by the build scripts are set to those specific values for good reason. -- Joe Mistachkin

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

3:59:59.999. -- Joe Mistachkin

<    1   2   3   4   5   6   7   >