Thanks, it worked perfect! _alenD
Roger Binns wrote: > > -----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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/creating-database-from-dump-file-within-C-code-tp27295724p27299030.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users