how to run sql script file in sqlite3 through objective-C

Question

Hi all,

Here is my question, when interacting with Sqlite 3 through terminal, you can execute SQL statements stored in a txt file by executing this command:

 .read filename

Is there a way to do such thing through Obj-C code? i.e. I've got a sqlite3 db file connected in the code, and i'd like to run a script file programmatically.

Thanks in advanced :)

Answer 1

You could forward the content of the file line by line, or in whole to the function exec