You may want to consider writing a bash/msdos-batch file and do your stuff from your OS command line
Bıt C API is quite handy, you can do most of the stuff with it. On 14/05/2013, at 10:29 PM, 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? > > > On Tue, May 14, 2013 at 6:07 PM, <fnoyan...@yahoo.com> wrote: > >> If you are dealing with CSV files, there is a simple API I wrote you can >> use. >> >> https://github.com/fnoyanisi/sqlite3_capi_extensions >> >> I was looking for .import functionality for C API, but I ended up writing >> my own fınctions. >> >> On 14/05/2013, at 9:39 PM, Richard Hipp <d...@sqlite.org> wrote: >> >>> On Tue, May 14, 2013 at 1:53 AM, Dulini Atapattu >>> <dulini.atapa...@gmail.com>wrote: >>> >>>> Hi all, >>>> >>>> I have some sqlite scripts with some sqlite commands like: >>>> >>>> - .headers ON >>>> - .mode CSV etc. >>>> >>>> Is there anyway of running this script in SqliteDB using Sqlite >> interface >>>> for C++, instead of redirecting the file to sqlite using sqlite command >>>> line shell? >>> >>> Those commands are implemented by the sqlite3 command-line shell, not by >>> the SQLite library. >>> >>> You can copy/paste the code out of the sqlite3 command-line shell source >>> code (www.sqlite.org/src/artifact/2109d54f67) and add that code to your >> C++ >>> application, I suppose. >>> >>> -- >>> D. Richard Hipp >>> d...@sqlite.org >>> _______________________________________________ >>> 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 > _______________________________________________ > 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
