On Mon, 25 Apr 2016 15:14:56 Dominique Devienne <ddevienne at gmail.com> wrote:
> Please (re)read the example I included. --DD > > C:\Users\DDevienne>sqlite3 *file:*new.db?mode=ro Sorry, perhaps I'm a bit obtuse. I don't see how your example differs from mine: sqlite "mydbpath?mode=ro" Are you referring to the "*file:*" syntax? --Mark -----Original Message----- > Date: Mon, 25 Apr 2016 15:14:56 +0200 > From: Dominique Devienne <ddevienne at gmail.com> > To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> > Subject: Re: [sqlite] sqlite3 command line, read-only > > On Mon, Apr 25, 2016 at 2:53 PM, Mark Foley <mfoley at novatec-inc.com> wrote: > > > On Mon, 25 Apr 2016 14:41:30 Dominique Devienne <ddevienne at gmail.com> > > wrote: > > > > > Perhaps you're missing the leading file: ? I believe it is required. --DD > > > > No, unless I'm putting it in the wrong place. As I wrote I did: > > $ sqlite3 "myDbpath?mode=ro" > > > > Please (re)read the example I included. --DD > > C:\Users\DDevienne>sqlite3 *file:*new.db?mode=ro > ... > sqlite> update t set v = 4; > *Error: attempt to write a readonly database* > sqlite> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >