Re: [sqlite] update value from another tow tables

You need brackets around the scalar value that is returned by the correlated subquery update table1 set name=(select name from table2 where table2.id=table1.id); This will update the name field in EVERY ROW of table1 with the value of name retrieved from table2, or with null if no matching

[sqlite] update value from another tow tables

updat table1 set name=selet name from table2 where table2.id=table1.id; this command couldn't work, how to update this status? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] result set not properly ordered in SQLite 3.7.15.1

Hi, I have this query: SELECT DISTINCT ask_fuo.id FROM ask_fuo INNER JOIN ask_art USING (id) INNER JOIN ask_art_personen USING (ora_nachweis_id) WHERE (ask_art_personen.code IN('M0E9','M0GC','M0YR')) AND ask_art_personen.bezug IN('B','D','S') GROUP BY ask_fuo.id ORDER BY ask_fuo.id; A sample

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

Michael Russell wrote: > > The File.Delete() fails with the same issue as above (System.IO.Exception: > The process cannot access the file...because it is being used by another > process.) > My guess would be that the Entity Framework is somehow holding the underlying connection open. I'm not

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

Thanks very much. That solved that problem. I'm seeing a similar issue when using an EntityFramework open: using (var testEntities = new SystemDataSQLiteTest.TestEntities(connectionString)) { var users = testEntities.Users.ToArray();

Re: [sqlite] Lock Database temporarily.

Regarding:*...and I require to lock the database **from any third party modification.* I know you wrote "modification," but I wondered if you have : a) a requirement to prevent even *reading* of the database by outsider programs. b) a requirement to ALLOW *reading* of the database by

Re: [sqlite] Lock Database temporarily.

On 8 Jan 2013, at 3:22pm, Dominique Devienne wrote: > Perhaps Santosh meant other SQLite-using 3rd party apps, as opposed to > anyone able to modify the DB file as you mentioned. Good point. Santosh, were you concerned about someone modifying the file while your

Re: [sqlite] Lock Database temporarily.

On Tue, Jan 8, 2013 at 2:17 PM, Simon Slavin wrote: > On 7 Jan 2013, at 4:46pm, sants87 wrote: > >> Hi I am using Sqlite3 for my application and I require to lock the database >> from any third party modification. Accessing database is fine but I

Re: [sqlite] Lock Database temporarily.

On 7 Jan 2013, at 4:46pm, sants87 wrote: > Hi I am using Sqlite3 for my application and I require to lock the database > from any third party modification. Accessing database is fine but I don't > want others to modify the same. i tried Sqlite encryption but that is not

[sqlite] Lock Database temporarily.

Hi I am using Sqlite3 for my application and I require to lock the database from any third party modification. Accessing database is fine but I don't want others to modify the same. i tried Sqlite encryption but that is not available for free. Is there other ways to achieve the same? Thanks

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 20:09:02 +0700 Dan Kennedy wrote: > On 01/07/2013 03:22 PM, Eduardo Morras wrote: > > > > Hi, I use sqlite in some of my projects. In one it follows a > > parent/multichild model (multifork). The database is managed by the > > parent, open close backups

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 7 Jan 2013 11:11:01 +0100 Pavlos Christoforou wrote: > Hello Eduardo, > > We do (succesfully) use sqlite in a similar manner as you describe in your > post but the code ensures the DB is opened in each individual child process > *after* a child is successfully forked.

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 7 Jan 2013 12:27:54 + Simon Slavin wrote: > > On 7 Jan 2013, at 8:22am, Eduardo Morras wrote: > > > The app works but, is anyone working with sqlite this way? Any advice to > > avoid db corrupts, deadlocks, whatever? > > Read this page: >

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 05:43:50 -0800 Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/01/13 00:22, Eduardo Morras wrote: > > opened before the fork, and after it the childs use the database > connection. I don't want to corrupt the database, >

Re: [sqlite] Using SQLite on a networkshare

Hi JCHD, Thnx for your notice. Of course I checked the AutoIt forum first. There is indeed some discussion on this topic, but no solution that worked for me. I also checked the solution by atensoft (actually I used this for a while, but couldn't find out how to properly write a wrapper for it in