I'm running this on Linux. That Windows notation doesn't work. sqlite3 "*file:*/mnt/tmp/Users/.../AppData/Roaming/Thunderbird/Profiles/8sbpxrwj.default/calendar-data/local.sqlite\?mode=ro" "select distinct value from cal_properties where key = 'CATEGORIES'" Error: unable to open database "*file:*/mnt/tmp/Users/hcarr.HPRS.000/AppData/Roaming/Thunderbird/Profiles/8sbpxrwj.default/calendar-data/local.sqlite\?mode=ro": unable to open database file
--Mark -----Original Message----- Date: Mon, 25 Apr 2016 15:47:27 +0200 From: Dominique Devienne <ddevie...@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 3:35 PM, Mark Foley <mfoley at novatec-inc.com> wrote: > 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? > Precisely: https://www.sqlite.org/uri.html --DD Since SQLite always interprets any filename that does not begin with "file:" > as an ordinary filename regardless of the URI setting > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
