Is this a 1 off import? If so, perhaps the command line tool can .read it.
On Fri, Apr 9, 2010 at 2:13 PM, Shaun Seckman (Firaxis) < shaun.seck...@firaxis.com> wrote: > Greetings, > > I've got a .SQL file that contains multiple SQL insert statements for > various tables as well as comments embedded throughout. When I > attempted to pass the file into sqlite3_exec, I found that only the > first SQL command was getting executed. What is the best way to ensure > that all commands are executed? Parsing the file line-by-line is > inaccurate as multiple statements may be on the same line and looking > for the next ';' character has parsing problems as well. > > > > The documents state that sqlite3_complete() only returns a 1 if the > statement is complete. Were this method to return the index into the > character array to denote WHERE the SQL statement is complete, I could > use that to parse multiple statements. > > > > Does anyone have any suggestions? > > > > -Shaun > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users