On 14 May 2013, at 1:59pm, Dulini Atapattu <dulini.atapa...@gmail.com> wrote:
> If anyway I omit these sqlite commands from script, so is there anyway of > providing the script file to API? If you strip out the lines which start with a dot, everything else in the script should be a legitimate SQL command. You could use the API to execute the whole thing as one bit _exec(). But it would be more conventional to read the file in a line at a time, and execute each line separately. You should write your own code to open the database file you want the results in, then do all the _exec() commands, checking the result returned to make sure there were no errors, then close the file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users