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

2014-09-18 Thread Joe Mistachkin
d 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

[sqlite] System.Data.SQLite version 1.0.94.0 released

2014-09-15 Thread Joe Mistachkin
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] Reinstalling My Build Environment

2014-09-12 Thread Joe Mistachkin
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] SQLite Development Team support of System.Data.SQLite (was RE: Reinstalling My Build Environment)

2014-09-12 Thread Joe Mistachkin
fully supported 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] System.Data.Sqlite.dll v93 performance issues...

2014-09-12 Thread Joe Mistachkin
e in your environment. -- 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

2014-09-11 Thread Joe Mistachkin
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] Reinstalling My Build Environment

2014-09-11 Thread Joe Mistachkin
les from the bin directory to a clean machine and > have 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

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

2014-09-08 Thread Joe Mistachkin
to Friday, 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] System.Data.SQLite - issues

2014-09-08 Thread Joe Mistachkin
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/downl

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

2014-09-05 Thread Joe Mistachkin
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 l

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

2014-08-29 Thread Joe Mistachkin
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

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

2014-08-28 Thread Joe Mistachkin
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] Possible bug in System.Data.Sqlite.Core (ADO.Net)

2014-08-28 Thread Joe Mistachkin
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)

2014-08-28 Thread Joe Mistachkin
;CountryCode") WHERE ("ProgrammingMapView"."ProductId" = 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(nam

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

2014-08-27 Thread Joe Mistachkin
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] Need help on SQLite In-Memory Mode

2014-08-08 Thread Joe Mistachkin
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] System.Data.Sqlite

2014-07-28 Thread Joe Mistachkin
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] System.Data.Sqlite

2014-07-28 Thread Joe Mistachkin
ble to 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 ___ sql

Re: [sqlite] System.Data.Sqlite

2014-07-28 Thread Joe Mistachkin
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] About Sqlite for Windowsphone

2014-07-20 Thread Joe Mistachkin
e: https://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] About Sqlite for Windowsphone

2014-07-20 Thread Joe Mistachkin
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

2014-07-20 Thread Joe Mistachkin
ences are 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 V

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

2014-07-17 Thread Joe Mistachkin
st I thought it was the NGQP (since I > upgraded from version 3.7 to 3.8.5), but while trying to break it down, it > appeared the issue was with this fetch method. > Slower for what types of values? This is another issue where the database schema and possibly some C# code demonstratin

Re: [sqlite] Working with SQLite-Net in Framework 2.0

2014-07-10 Thread Joe Mistachkin
g Native Library Pre-Loading" and "Deployment Guidelines" sections merit special attention. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Working with SQLite-Net in Framework 2.0

2014-07-10 Thread Joe Mistachkin
package instead of deploying application locally? Are you actually going to use the Visual Studio designer support? > > Can the two versions co-exist, or will there be problems? > In theory, yes; however, that configuration has *NOT* been te

Re: [sqlite] Basic SQLite/EF6 question

2014-07-10 Thread Joe Mistachkin
;install" the Entity Framework 6 package (via NuGet) into the target project). I am not aware of any other required steps. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-10 Thread Joe Mistachkin
f machine-wide configuration, hence the confusion here (i.e. especially since the components are in completely different assemblies). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-07 Thread Joe Mistachkin
e installation. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-05 Thread Joe Mistachkin
the install was successful. I > don't know if that is a clue to what the problem might be. > That is expected behavior now that the installer launches VS in "setup" mode to refresh it's internal settings. -- Joe Mistachkin __

Re: [sqlite] Basic SQLite/EF6 question

2014-07-04 Thread Joe Mistachkin
ers" sections, e.g.: https://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=testlin q/2010/EF6/App.config&ln=6-12 -AND- https://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=testlin q/2010/EF6/App.config&ln=1

Re: [sqlite] Basic SQLite/EF6 question

2014-07-04 Thread Joe Mistachkin
lit e-netFx451-setup-bundle-x86-2013 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building with sqlite in C#

2014-06-29 Thread Joe Mistachkin
et it copied to the build directory when setting up a project? > The recommended way to handle this is by using the NuGet package, e.g.: https://www.nuget.org/packages/System.Data.SQLite/ -- Joe Mistachkin ___ sqlite-users mailing list sqlit

[sqlite] System.Data.SQLite version 1.0.93.0 released

2014-06-23 Thread Joe Mistachkin
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] importing CSV with a random empty line at the end

2014-06-16 Thread Joe Mistachkin
Thanks for the report. Fixed on trunk, here: https://www.sqlite.org/src/info/fc918f7d33 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-06-16 Thread Joe Mistachkin
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 this coming Friday, June 20th. Thanks. -- Joe Mistachkin ___ sqlite-users ma

Re: [sqlite] System.Data.SQLite failing in Windows 7

2014-06-13 Thread Joe Mistachkin
Calvert, Jim wrote: > > Is there anybody from the developers of SQLite who can comment on this issue > for me. > I did reply to your original post. Here is a link to the thread: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg84247.html -- Jo

Re: [sqlite] System.Data.SQLite failing in Windows 7

2014-06-12 Thread Joe Mistachkin
was released in April of 2010). It might be worthwhile to contact the vendor of the application and gently urge them to upgrade. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 database on windows network drive and unreliable connection

2014-05-27 Thread Joe Mistachkin
Denis Y. Zibarev wrote: > > The problem goes down to winLock() implementation, particularly to winLockFile() ... > I've made some experimental changes on the winLockHandle branch that should address this issue; however, I still need to add some tests to verify the new beh

Re: [sqlite] Release date of Windows Phone 8.1 SQLite

2014-05-22 Thread Joe Mistachkin
Klemen Forstneric wrote: > > is there a release date for the Windows Phone 8.1 version of SQLite (the > one available here: > http://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2a f75d1b) > The current plan is to release it when SQLite 3.8.5 is re

Re: [sqlite] Code Error -- Cannot compile Amalgamation with SQLITE_THREADSAFE=0 on WIndows

2014-05-11 Thread Joe Mistachkin
tion, per se. Short term, modifying "mutex_w32.c" to include "os_win.h" inside a SQLITE_OS_WIN block instead of the SQLITE_MUTEX_W32 block seems better. Long term, modifying the amalgamation tooling to better handle includes that occur within #ifdef's would be nice. -- Joe Mistac

Re: [sqlite] Compiling System.Data.SQLite for .NET CF 3.5 (VS2008 & WinCE 6) on x86

2014-05-09 Thread Joe Mistachkin
Eric Johnston wrote: > > The question is: How do I compile System.Data.SQLite for .NET CF 3.5 (VS2008) > with a target platform of x86 for the SQLite.Interop.092.dll? > The Windows CE 6.x SDKs that I've seen do not include support for the x86 platform. Are you aware of one t

Re: [sqlite] Could not open registry key

2014-05-07 Thread Joe Mistachkin
etup in order to install the System.Data.SQLite assemblies into the GAC and setup the design-time components for Visual Studio. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a single file version of System.Data.SQLite?

2014-05-07 Thread Joe Mistachkin
be made to work properly: https://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=Doc/Ext ra/Provider/environment.html Largely, it depends on the specifics of your environment, which I'm not really familiar with. -- Joe Mistachkin _

Re: [sqlite] SQLite with Entity Framework problem

2014-05-06 Thread Joe Mistachkin
r the associated entity class? > > The version of SQLite I'm using is 1.0.92.0 and the entity framework is > 6.0.0.0. > Is the version of Entity Framework exactly 6.0.0.0 or is it something like 6.0.0.2? -- Joe Mistachkin ___ sql

Re: [sqlite] Is there a single file version of System.Data.SQLite?

2014-05-06 Thread Joe Mistachkin
en here: http://msdn.microsoft.com/en-us/library/ky3942xh%28v=vs.110%29.aspx -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows Phone 8.1

2014-05-05 Thread Joe Mistachkin
Ryan Finnesey wrote: > > Has anyone confirmed this is something in the works? > It's actively being worked on. -- 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

2014-04-24 Thread Joe Mistachkin
appear in the list. > None of the NuGet packages for System.Data.SQLite install the design-time components for Visual Studio, since that would require various machine-wide changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] cannot set connection while a datareader is active

2014-04-21 Thread Joe Mistachkin
a restriction on resetting the underlying connection for a command when data readers are active. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-21 Thread Joe Mistachkin
ctive data reader, it is NOT the one that was closed just above that point in the code. I'm not sure how the project manages data reader instances; however, it would appear that System.Data.SQLite is throwing exceptions just as it should in this case. -- Joe Mistachkin ___

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Joe Mistachkin
Since this mailing list strips attachments, you could post a link to a ZIP file that can be downloaded. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Joe Mistachkin
ight help me to narrow down exactly what caused the SQLiteCommand to get into a state where the connection cannot be reset. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What does Installer.exe do in the binary packages?

2014-04-18 Thread Joe Mistachkin
setting up the design-time components for Visual Studio. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-16 Thread Joe Mistachkin
ll debugging information for them. I recommend adding the "System.Data.SQLite.20XX.csproj" and "SQLite.Interop.20XX.vc[x]proj" projects that correspond to the version of Visual Studio you are using. Then, you'll want to reset the reference to point to the project instead of t

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Joe Mistachkin
Ralf wrote: > > I just tried... No change :-( > Have you looked at the contents of the database using the SQLite command line tool for Windows? https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip -- Joe Mistachkin ___ sql

Re: [sqlite] cannot set connection while a datareader is active

2014-04-15 Thread Joe Mistachkin
Stefano Ravagni wrote: > > So what have i do? Need to see others setting or state? > It would be useful to try and examine the internal state of the SQLiteCommand and see if the _activeReader member is valid. If it is valid, see if it actually refers to the data reader you are using

Re: [sqlite] Database access slowness on specific WinCE devices

2014-04-15 Thread Joe Mistachkin
ainst the other devices you have. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
t might also exhibit the type of behavior you are seeing. Please try using the four leading backslashes and let us know the outcome. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Joe Mistachkin
it does not show the internal state of the SQLiteCommand object throwing the exception. When the Close() method of the SQLiteDataReader is called, it should end up calling ClearDataReader on the associated SQLiteCommand. In this case, that may not be happening

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Joe Mistachkin
ated with the command you are attempting to set the connection of. Are you 100% sure that the "Dati" data reader is associated with the "objCmd" command? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database access slowness on specific WinCE devices

2014-04-14 Thread Joe Mistachkin
it exhibits somewhat degraded performance due to block relocations, etc)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
Ralf Jantschek wrote: > >$cn.ConnectionString = "Data Source=\\..." > If you are opening a database on a network share, there must now be four leading backslashes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-us

Re: [sqlite] cannot set connection while a datareader is active

2014-04-13 Thread Joe Mistachkin
Not Dati Is Nothing Then In theory, changing the "If" expression should not make any difference; however, I seem to recall that the IsNothing function was typically used for checking the sub-type of a Variant (i.e. and not for checking for null references). Of course, I have not used

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-11 Thread Joe Mistachkin
t; "Select * from table;" > > But the select doesn't return "1 2" as expected, it returns the FieldCount > which is 2 > > I am accessing SQlite in a powershell script > Could you also please show the PowerShell script that is being used to

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
this issue, I'll need to see the code for the "CloseDati" routine. This is necessary because I am unable to reproduce the issue thus far. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
post the code for the "CloseDati" routine? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-09 Thread Joe Mistachkin
teCommand object while an active data reader is attached to it. Normally, the Connection property of the SQLiteCommand object should not need to be set. I'm somewhat curious why it needs to be set in this case. -- Joe Mistachkin ___ sqlite-user

Re: [sqlite] LINQ - SQLite | Compact Framework 3.5?

2014-04-08 Thread Joe Mistachkin
port CF. > The official .NET wrapper for SQLite, System.Data.SQLite, does support the .NET Compact Framework, see: https://system.data.sqlite.org/ -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Joe Mistachkin
#x27;m understanding your question correctly. For now, I'll assume you can modify the CREATE TABLE statement itself. In that case, you can make use of the PRIMARY KEY clause on one of the column definitions, such as: CREATE TABLE t1(x TEXT PRIMARY KE

Re: [sqlite] SQLite in Windows Phone Runtime Component

2014-03-28 Thread Joe Mistachkin
12; however, it may be possible to get it working with Visual Studio 2013. http://visualstudiogallery.msdn.microsoft.com/cd120b42-30f4-446e-8287-45387a 4f40b7 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
===> No > > Many thanks, > MB > Is the sqlite3_shutdown() function being called at some point? If so, the temporary directory will need to be reset after that point. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
/error log entries are you seeing when you set the temporary directory to the LocalState directory? Does the application have full read/write access to that directory? Are any PRAGMAs being executed prior to the query with the issue? -- Joe Mistachkin __

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

2014-03-27 Thread Joe Mistachkin
5b5-8a37-ef048f > f7a7fb_agzj39a4a6zwt\\LocalState" > Sure, that's fine. However, the string must be UTF-16. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missingdatabase) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

2014-03-27 Thread Joe Mistachkin
mporary directory should be set prior to the first database connection being opened. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Joe Mistachkin
ows Phone 8). > > I have tried your suggestion anyway, but no result. > Can you enable the SQLite error logging mechanism, which may provide more details as to the root cause of the issue? It's described here: https://www.sqlite.o

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Joe Mistachkin
e temporary directory value should work fine. -- 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.92.0 released

2014-03-19 Thread Joe Mistachkin
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] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-19 Thread Joe Mistachkin
not all x86 contents...is right ? > If you use one of the mixed-mode assemblies, yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-03-17 Thread Joe Mistachkin
ly. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-03-17 Thread Joe Mistachkin
inary directory? This is especially important for the "x86" and "x64" directories within the archive. They should be extracted verbatim into the application binary directory. Also, you might need to recompile your application to refer to the new version of System.Data.

Re: [sqlite] SQLite Interop exception

2014-03-17 Thread Joe Mistachkin
uot; build configuration. By default, that setup is not supported. The simplest workaround is to change the active build configuration in Visual Studio to "ReleaseNativeOnly" and try again. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-user

Re: [sqlite] [sqlite-dev] Final preparations for the releaseof System.Data.SQLite v1.0.92.0 have begun...

2014-03-16 Thread Joe Mistachkin
Stefano Ravagni wrote: > > If yes, i like this way! When could i try the compiled version for make somes tests? > Here is a temporary set of debug binaries for the .NET Framework 4.0 (or higher): https://system.data.sqlite.org/temporary/System.Data.SQLite-StickyHasRows-59 fcdb.zi

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

2014-03-16 Thread Joe Mistachkin
roperty to include the StickyHasRows value, e.g.: "Data Source=:memory:;Flags=StickyHasRows;" Currently, these changes can be seen on the stickyHasRows branch, here: https://system.data.sqlite.org/index.html/timeline?r=stickyHasRows Would thi

Re: [sqlite] System.Data.SQLite Deployment Mystery

2014-03-16 Thread Joe Mistachkin
tp://dependencywalker.com/ ) against the native interop assembly ("SQLite.Interop.dll") on the target machine should reveal if that is the case. If that does turn out to be the case, it can normally be solved by installing one of the packages from: https://support.microsof

Re: [sqlite] SQLite exception

2014-03-14 Thread Joe Mistachkin
Rishi Ravindran wrote: > > I am getting an exception when I try to debug > the sqlite-netFx-source-1.0.91.0 source code in VS 2010 on the following > line below... > https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q20 --

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

2014-03-13 Thread Joe Mistachkin
)) { hasRows = true; // process this row... } else { // no more rows. break; } } while (true); if (hasRows) { // mor

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

2014-03-13 Thread Joe Mistachkin
your use case, when combined with the HasRows property, e.g.: If Dati.HasRows = True Or Dati.StepCount > 0 Then ... code here ... End If This new property will be present in the 1.0.92.0 release, due out next week. -- Joe Mistachkin ___

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

2014-03-12 Thread Joe Mistachkin
test that demonstrates how this works, here: https://system.data.sqlite.org/index.html/ci/7fb5c1cd3e?sbs=0&w Based on your previous statements, it sounds like you may have expected the return value of the HasRows property to remain constant (i.e. even after reading some o

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

2014-03-12 Thread Joe Mistachkin
Stefano Ravagni wrote: > > i encounter problem with datareader hasrows properties... > Do you have some example code that demonstrates the issue? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] What does SQLITE_OS_WINRT mean

2014-03-12 Thread Joe Mistachkin
> > What does the macro SQLITE_OS_WINRT mean? > When it is set to non-zero, it means that the SQLite core library is being built specifically for the Windows Runtime (present on Windows 8.x): https://en.wikipedia.org/wiki/Windows_Runtime -- Joe M

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-11 Thread Joe Mistachkin
erty for the temporary directory value should work fine. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Joe Mistachkin
TFX_CORE SQLite3.SetDirectory(/*temp directory type*/2, Windows.Storage.ApplicationData.Current.TemporaryFolder.Path); #endif Can you please try removing the surrounding "#if" from this code and try it again? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-03-10 Thread Joe Mistachkin
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 this coming Friday, March 14th. Thanks. -- Joe Mistachkin ___ sqlite-use

Re: [sqlite] Issues after upgrade to 3.8.2

2014-03-05 Thread Joe Mistachkin
] as s where s.[SongId] = new.[SongId])," > Thanks for the detailed report. This issue has been fixed on trunk: https://www.sqlite.org/src/info/5bcd0b1ca5 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] System.Data.SQLite fails to load

2014-02-28 Thread Joe Mistachkin
unless > I know exactly what they're going to do, that's why I'm asking. > Using "gacutil" is fine. That's more-or-less what the setup packages do. -- 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 fails to load

2014-02-25 Thread Joe Mistachkin
e loads the System.Data.SQLite assembly (or other assemblies); however, maybe try using the "LoadFrom context" when loading from the network share as well. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Should System.Data.SQLite.EF6.SQLiteProviderServices be public?

2014-02-23 Thread Joe Mistachkin
public before (i.e. in the plain System.Data.SQLite.Linq assembly). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EF6 + System.Data.Sqlite SaveChanges() not working?

2014-02-18 Thread Joe Mistachkin
gt; This might be a problem with the configuration file. There was an issue with the NuGet configuration file transforms that is now fixed in package version 1.0.91.1. Could you try the new version and see if that clears the issue you are seeing?

Re: [sqlite] System.Data.SQLite documentation

2014-02-13 Thread Joe Mistachkin
operties" tab, click the "Unblock" button, and then click the "Apply" button. -- 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 documentation

2014-02-13 Thread Joe Mistachkin
trunk/www/faq.wiki And the download page: 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:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] C# - SQLite - and other things

2014-02-13 Thread Joe Mistachkin
n the Visual Studio IDE): https://nuget.org/api/v2/package/System.Data.SQLite/1.0.91.0 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<    1   2   3   4   5   6   7   >