-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 alenD wrote: > Is there a way to create and populate a sqlite database from an already > created dump file within C code.
Load the dump text so you have it as one long string and then call sqlite3_exec pointing to that string. Behind the scenes what happens is that sqlite3_prepare is called, then sqlite3_step until done then sqlite3_finalize. sqlite3_prepare only works on the first statement, but tells you where the next one begins so this is done in a loop until there are no next statements. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktcfIoACgkQmOOfHg372QRJ7QCg0/X3/cZLYa9bW6lJE1BJwmzL PdUAn3FVe9+WOe6/Q0cgSLJXFgv5iP/f =glCf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
