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

[Dulini Atapattu]

Thanks


On Fri, May 17, 2013 at 11:08 PM, Igor Tandetnik  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
>
___
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

[Igor Tandetnik]

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

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

[Dulini Atapattu]

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

[Dulini Atapattu]

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