Ah, I believe it is something that the command line tool can .read. Since I'm using just the static library, I'll have to copy the functionality from shell.c into my own code.
Thanks! -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Adam DeVita Sent: Friday, April 09, 2010 2:52 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite parsing of a .sql file 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
