Thank you Igor
On 21 June 2011 12:52, Igor Tandetnik <[email protected]> wrote: > e-mail mgbg25171 <[email protected]> wrote: > > Howto...multi-sqlite command string through sqlite3_prepare_v2() to > create SINGLE statement > > You can't do that. > > > sql = "BEGIN"; //you need to add newline here > > sql += "create table episodes (id integer primary key, season int, name > > text)"; > > sql += "insert into episodes(id, season, name) Values(1,2,'bill')"; > > sql += "insert into episodes(id, season, name) Values(2,3,'bob')"; > > sql += "COMMIT"; > > sqlite3_exec can be used to execute multiple statements like this in a > single call. You do need to terminate each statement with a semicolon. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
