on Mon, 25 Apr 2016 09:10:58 Richard Hipp <drh at sqlite.org> wrote: > Can you use the ".once /dev/null" command prior to the "PRAGMA" to > suppress the output?
sqlite3 -cmd ".once /dev/null" -cmd "PRAGMA busy_timeout=5000" "mydbpath" \ "select distinct value from cal_properties where key = 'CATEGORIES'" Error: unknown command or invalid arguments: "once". Enter ".help" for help 5000 Orange Category Green Category Blue Category Purple Category Blue Category,Holidays Personal Perhaps too old a version of sqlite3? Doing .help does not list .once, but it does list: .timeout MS Try opening locked tables for MS milliseconds I tried that, but perhaps I've got the syntax wrong: sqlite3 "mydbpath" \ ".timeout 5000;select distinct value from cal_properties where key = 'CATEGORIES'" Error: unknown command or invalid arguments: "timeout". Enter ".help" for help Putting it in a -cmd (following your example): sqlite3 -cmd ".timeout 5000" "mydbpath" \ "select distinct value from cal_properties where key = 'CATEGORIES'" Orange Category Green Category Blue Category Purple Category Blue Category,Holidays Personal Didn't give an error and didn't echo the 5000 to stdout. Do you suppose that will work? --Mark -----Original Message----- > Date: Mon, 25 Apr 2016 09:10:58 -0400 > From: Richard Hipp <drh at sqlite.org> > To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> > Subject: Re: [sqlite] sqlite3 command line, read-only > > On 4/25/16, Mark Foley <mfoley at novatec-inc.com> wrote: > > > > Thanks, I just tried that. It's a good ides, but the problem is that the > > PRAGMA > > statement echo the timeout value to stdout: > > > > Can you use the ".once /dev/null" command prior to the "PRAGMA" to > suppress the output? > > sqlite3 "mydbpath" -cmd ".once /dev/null" -cmd "PRAGMA > busy_timeout=5000" "select distinct value from cal_properties where > key = 'CATEGORIES'" > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
