Re: [sqlite] System.Data.SQLite: Commit and Rollback set Connection tonull

> The Connection property is not guaranteed by the MSDN documentation to > remain valid after a call to Commit or Rollback. It's really an internal > implementation detail. > > > http://msdn.microsoft.com/en-us/library/system.data.idbtransaction.connection.aspx > Indeed, I already checked MSDN

Re: [sqlite] sqlite version of android 4.0.3

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/01/13 16:23, sqlitekyounoii wrote: > I want to know sqlite version of android 4.0.3 My 4.0 device is 4.0.4 but I doubt they changed it. The version number is 3.7.4 and the source id is 2011-02-23 14:33:31

Re: [sqlite] sqlite version of android 4.0.3

~Android gingerbread: 3.6.22 Honeycomb~ICS: 3.7.4 Jellybean~:3.7.11 On Jan 10, 2013 9:23 AM, "sqlitekyounoii" wrote: > I want to know sqlite version of android 4.0.3 > > It's bundle, so version is not know. > ___ >

Re: [sqlite] System.Data.SQLite: Commit and Rollback set Connection tonull

RizThon wrote: > > I don't know if it's the right mailing list to talk about > System.Data.SQLite.dll. > Yes, this is the right place. > > DbTransaction has a property Connection that corresponds to the connection > used by the transaction. I don't understand why calling Commit or Rollback >

Re: [sqlite] compiling tools for winrt

E. Timothy Uy wrote: > > Hi, in xcompiling tools for winrt I get the errors below. I suspect this > because I am using the vcvars for cross compiling winrt. Is there a way to > make this work? > In order to build for WinRT, extra options are required on the NMAKE command line. Here is an

[sqlite] System.Data.SQLite: Commit and Rollback set Connection to null

Hi, I don't know if it's the right mailing list to talk about System.Data.SQLite.dll. DbTransaction has a property Connection that corresponds to the connection used by the transaction. I don't understand why calling Commit or Rollback on the transaction automatically sets that property to null.

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Michael Russell wrote: > > I did do a check-out after you made the above suggestion to me. I did the > fossil checkout / build, but I still have the same problem. > Is there any way you can determine which System.Data.SQLite objects are being held open by the Entity Framework? -- Joe

Re: [sqlite] sqlite version of android 4.0.3

On 10 Jan 2013, at 12:23am, sqlitekyounoii wrote: > I want to know sqlite version of android 4.0.3 > > It's bundle, so version is not know. On whatever platform you're interested in, execute the SQL command SELECT sqlite_version() See this page for details:

[sqlite] sqlite version of android 4.0.3

I want to know sqlite version of android 4.0.3 It's bundle, so version is not know. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling tools for winrt

Thanks Dimiter. I ended up making this change in Makefile.msc 165 165 !IFNDEF NSDKLIBPATH 166 -NSDKLIBPATH = $(WINDOWSSDKDIR)\lib 166 +NSDKLIBPATH = $(WINDOWSSDKDIR)\Lib\win8\um\x86 167 167 !ENDIF On Wed, Jan 9, 2013 at 4:07 PM, Dimiter 'malkia' Stanev wrote: > This looks

Re: [sqlite] compiling tools for winrt

This looks like general compile problem. The imported functions below are found in kernel32.dll (kernel32.lib import library). But I'm not sure whether under WinRT kernel32.dll is still used (it might be). If you can either add kernel32.lib to your link flags, or with pragma #ifdef _MSC_VER

Re: [sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

I see; well, that's unfortunate. At any rate, parsing lempar.c will probably be much more complex than the code I have now, which solves a simple (but common) case. Maybe I'll look into parsing lempar.c, but since this solves my use case, I probably won't be in a hurry to do it. I apologise to

Re: [sqlite] Lock Database temporarily.

It sounds to me like your question has nothing to do with SQLite and everything to do with the operating system your app is (not) running on. What facilities does your OS have to stop anything or anybody writing a file? How do you propose to relax these facilities to enable your app to write the

[sqlite] compiling tools for winrt

Hi, in xcompiling tools for winrt I get the errors below. I suspect this because I am using the vcvars for cross compiling winrt. Is there a way to make this work? MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol __imp__IsDebuggerPresent@0 referenced in function

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

I did do a check-out after you made the above suggestion to me. I did the fossil checkout / build, but I still have the same problem. -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On Wed, Jan 9, 2013 at 2:54 PM,

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Larry Brasfield wrote: > > I don't know about data adapter usage, but I am seeing the same behavior > with Entity Framework version 5. I have scrupulously disposed of > everything my code has gotten. I have also overridden the > DbContext.Dispose(bool disposing) method and can see that the

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Joe Mistachkin wrote: Does the Entity Framework make use of data adapters? If so, I just checked in a fix to dispose the internal commands managed by the SQLiteDataAdapter class (i.e. because the base class DbDataAdapter apparently does not explicitly dispose them). I don't know about data

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Does the Entity Framework make use of data adapters? If so, I just checked in a fix to dispose the internal commands managed by the SQLiteDataAdapter class (i.e. because the base class DbDataAdapter apparently does not explicitly dispose them). Could you please try the latest trunk code and let

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0inSystem.Data.SQLite

Everything that can be disposed of should be getting done automatically by the using: using (var testEntities = new TestEntities(connectionString)) { Assert.AreEqual(1, testEntities.Users.Count(), "Must be one user"); var firstOrDefault =

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

> > Mensaje original > De: Pavel Ivanov > Para: a...@zator.com, General Discussion of SQLite Database > > Fecha: Wed, 09 Jan 2013 16:08:51 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.75 version and > later > >

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0inSystem.Data.SQLite

Michael Russell wrote: > > One further follow-up. I tested all the other versions in between. The > break happened between 1.0.81.0 and 1.0.82.0 > The switch to using sqlite3_close_v2 happened in that time frame; however, the root cause of the issue you are seeing is that one or more

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 inSystem.Data.SQLite

One further follow-up. I tested all the other versions in between. The break happened between 1.0.81.0 and 1.0.82.0 -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On Wed, Jan 9, 2013 at 10:47 AM, Michael Russell

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 inSystem.Data.SQLite

I have narrowed this down and to just the System.Data.SQLite.DLL. I have a test project in VS2010 with .NET 4.0. If I only change the System.Data.SQLite.DLL from 1.0.79.0 to 1.0.83.0 I get the failure that the file is open. I am not changing any other components or DLL's. -- Michael Russell

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

On Wed, Jan 9, 2013 at 6:06 AM, wrote: > > > > > Mensaje original > > De: Clemens Ladisch > > Para: sqlite-users@sqlite.org > > Fecha: Wed, 09 Jan 2013 14:25:31 +0100 > > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version >

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

> > Mensaje original > De: Clemens Ladisch > Para: sqlite-users@sqlite.org > Fecha: Wed, 09 Jan 2013 14:25:31 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version > andlater > > > >a...@zator.com wrote: >>int resp =

Re: [sqlite] Archive SQLite Database?

You can also just copy the entire file (best to do when app is not running). So you'd only be down for as long as it takes to copy it. If your database is updated frequently .backup may never finish. Then you can archive from the copy and delete the archived rows from the active DB in a

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

a...@zator.com wrote: >int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM > dbOrig.usr", -1, , 0); if (resp != SQLITE_OK) printf("error message: %s\n", sqlite3_errmsg(dbPtr)); Regards, Clemens ___ sqlite-users

Re: [sqlite] Archive SQLite Database?

On 8 Jan 2013, at 2:05pm, "Jimmy Martin" wrote: >I have recently taken over a position that uses a SQLite > database. The database is currently 24GB and running extremely slow. Your best friend here might be the SQLite shell tool:

Re: [sqlite] Archive SQLite Database?

Tou haven't said what "really slow" means. Could be multiple solutions to that problem. 30min for 3-5MB sounds a bit ridiculous. What kind of select are you doing to archive and what indexes are on the tables? -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Lock Database temporarily.

Simon, To answer your question, I want to stop modification when my app is not running/alive. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Lock-Database-temporarily-tp66434p66454.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Lock Database temporarily.

Thanks Simon/devienne Donald, I just want my app to use the database. But as the database resides in a common easy accessible location I want to lock the database or prevent any access to it. I don't want other apps or even user using that database. I just want to block the writes. I am fine

[sqlite] Archive SQLite Database?

Hello, I have recently taken over a position that uses a SQLite database. The database is currently 24GB and running extremely slow. Is there a quick way to archive data and free-up some space? Also, are there any risks to running the "vacuum" command...such as losing data? I

[sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later

Hi list: I've an application who from a long time, worked in Windows 98; XP; Vista; W7, and now in W8. The things go fine until now, but with SQLite versions 3.7.15 and 3.7.15.1, sqlite3_prepare_v2() fails and return 1. Here is a brief of the situation: 1.- The application is running in a