On 31 Mar 2010, at 4:21pm, Kevin M. wrote: > Hopefully I'm not duplicating a question, but I looked on sqlite.org and did > not find the answer... > > Will this: > BEGIN TRANSACTION; > .read somefile.sql > END TRANSACTION; > > Put everything in the sql file into one transaction? Or do I need to put the > BEGIN/END TRANSACTION statements in the sql file itself?
Either way will work. Actually I don't know how '.read' works; the code may already wrap it inside a transaction, which would make both pointless. But they won't do any harm. Warning: From your phrasing it's possible you're thinking of putting a '.read' command into your program. The '.read' command is only a command to the command-line tool. It's not a function of SQLite, and you can't submit it as a query in your program. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
