[sqlite] Running sqlite script in Sqlite db using C++

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? Thanks

Re: [sqlite] Running sqlite script in Sqlite db using C++

thub.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 >

[sqlite] Getting datatypes of columns in a resultset from an SQLITE view

Hi, Is it possible to get the data types of columns in a result set that is obtained using a view in an sqlite database? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting datatypes of columns in a resultset from an SQLITE view

Adding more to my question, is it possible to get the datatypes using sqlite3_column_type(p_Stmt, iCol)? On Fri, May 17, 2013 at 11:00 PM, Dulini Atapattu <dulini.atapa...@gmail.com > wrote: > Hi, > > Is it possible to get the data types of columns in a result set that is &

Re: [sqlite] Getting datatypes of columns in a resultset from an SQLITE view

> > Igor Tandetnik > > > On 5/17/2013 1:32 PM, Dulini Atapattu wrote: > >> Adding more to my question, is it possible to get the datatypes using >> sqlite3_column_type(p_Stmt, iCol)? >> >> >> On Fri, May 17, 2013 at 11:00 PM, Dulini Atapattu < >> du

[sqlite] SQLITE_REAL was not declared in this scope

Hi, In C++ I am using SQLITE_INTEGER, SQLITE_TEXT etc. to identify integer and text values respectively, int columns of sqlite resulting rows, but when I use SQLITE_REAL to identify double values, the compiler says: 'SQLITE_REAL' was not declared in this scope. Can I please know the reason for

Re: [sqlite] SQLITE_REAL was not declared in this scope

Many thanks for the answer! On Sat, May 18, 2013 at 11:40 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 5/18/2013 2:05 PM, Dulini Atapattu wrote: > >> when I use SQLITE_REAL to identify double values, the compiler says: >> 'SQLITE_REAL' >> was not declared in