-- #/bin/sh ROW_ID=`sqlite3 test.db <<END insert into t values(1,2); select last_insert_rowid() from t limit 1; END ` echo ROW_ID=$ROW_ID --
^ that worked perfectly. Thank you Nikola! -- View this message in context: http://www.nabble.com/Capturing-output-from-SQLlite-with-variables-in-a-BASH-script-tf3966729.html#a11262060 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------