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