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 this scope. >> > > Which part of the documentation suggested to you that SQLITE_REAL exists? > You are probably thinking about SQLITE_FLOAT (http://sqlite.org/c3ref/c_** > blob.html <http://sqlite.org/c3ref/c_blob.html>) > -- > Igor Tandetnik > > __**_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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] 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 this and how can I identify data type of a column with a float value in sqlite? ___ 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
Thanks On Fri, May 17, 2013 at 11:08 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > Yes, as long as p_Stmt is positioned on a row (that is, the last call to > sqlite3_step returned SQLITE_ROW). > > In SQLite, columns don't really have types; only individual values do. > > 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 < >> dulini.atapa...@gmail.com >> >>> wrote: >>> >> >> 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<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
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 > 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
[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] Running sqlite script in Sqlite db using C++
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] 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users