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 <[email protected]> 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, <[email protected]> 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 <[email protected]> wrote: >> >>> On Tue, May 14, 2013 at 1:53 AM, Dulini Atapattu >>> <[email protected]>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 >>> [email protected] >>> _______________________________________________ >>> sqlite-users mailing list >>> [email protected] >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
