Yes, I am typing the stars in. That was my question to you to which you replied in your message of 15:47 +0200
>> Are you referring to the "*file:*" syntax? > > Precisely: https://www.sqlite.org/uri.html --DD I took you litterally, no I didn't look up the URL. ANYWAY, Yes!!! That works removing the stars: $ sqlite3 \ 'file:/mnt/tmp/Users/hcarr.HPRS.000/AppData/Roaming/Thunderbird/Profiles/8sbpxrwj.default/calendar-data/local.sqlite?mode=ro' \ "select distinct value from cal_properties where key = 'CATEGORIES'" Orange Category Green Category Blue Category Purple Category Blue Category,Holidays Personal I *told* you I was obtuse!!! So, I'll use that in combination with the "-cmd timeout=5000" just to be sure a writer doesn't lock me out anyway! Thanks a bunch --Mark -----Original Message----- Date: Mon, 25 Apr 2016 18:21:33 +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 6:12 PM, Mark Foley <mfoley at novatec-inc.com> wrote: > Nope: still error: > > sqlite3 \ > '*file:*/mnt/tmp/Users/hcarr.HPRS.000/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 > Are you trying to highlight something in the email, or do you really type the stars/asterisks around file? You shouldn't. Sorry, can't help you more, I'm afraid you're not reading me correctly, or I'm not writing correctly for you. --DD PS: See, no stars below sqlite3 \ 'file:/mnt/tmp/Users/hcarr.HPRS.000/AppData/Roaming/Thunderbird/Profiles/8sbpxrwj.default/calendar-data/local.sqlite?mode=ro' \ "select distinct value from cal_properties where key = 'CATEGORIES'" _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
