Hi all, I have a script containing the following, which works fine except that at the end of the script I get "SQL error near line 5: cannot commit - no transaction is active". The table specified in the file on line 2 gets created just fine, and populated just fine on line 4. I am using sqlite 3.6.7, custom built with new column limits and variable limits.
If someone could explain that would be great. I can supply more info, but it doesn't seem necessary yet. TIA Code in Question: $SQLLITE3 "NSLY-db.sqlite3" <<EOF BEGIN TRANSACTION; .read "$BASE.schema.sql" -- line 3, file contains a create table statement, works great .separator , .import $BASE.csv.strip NLSY79 -- line 4, file contains csv data works great COMMIT TRANSACTION; -- line 5, doesn't work for some reason EOF _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
