Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Mikhail Terekhov
On Fri, May 14, 2010 at 12:38 PM, Fabio Spadaro wrote: > > No, i'm sure. Probably typeof in python's sqlite is not supported very mell > or there is other explanation. > It works perfectly in Python: In [2]: import sqlite3 In [3]: conn = sqlite3.connect(':memory:') In

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread P Kishor
On Fri, May 14, 2010 at 11:38 AM, Fabio Spadaro wrote: > Hi, > > 2010/5/14 P Kishor > >> On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro >> wrote: >> > Hi, >> > >> > 2010/5/14 P Kishor >> > >> >> On

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Simon Slavin
On 14 May 2010, at 5:38pm, Fabio Spadaro wrote: > No, i'm sure. Probably typeof in python's sqlite is not supported very mell > or there is other explanation. It works perfectly inside SQLite: sqlite> CREATE TABLE tabA (a INTEGER, B INTEGER); sqlite> INSERT INTO tabA VALUES (1,10); sqlite>

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Fabio Spadaro
Hi, 2010/5/14 P Kishor > On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro > wrote: > > Hi, > > > > 2010/5/14 P Kishor > > > >> On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro > > >> wrote: > >> > hi, >

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread P Kishor
On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro wrote: > Hi, > > 2010/5/14 P Kishor > >> On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro >> wrote: >> > hi, >> > >> > 2010/5/14 P Kishor >> > >> >> On Fri,

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Fabio Spadaro
Hi, 2010/5/14 P Kishor > On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro > wrote: > > hi, > > > > 2010/5/14 P Kishor > > > >> On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro > > >> wrote: > >> > I need

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread P Kishor
On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro wrote: > hi, > > 2010/5/14 P Kishor > >> On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro >> wrote: >> > I need to identify data types extracted from a >> > join between multiple

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Fabio Spadaro
hi, 2010/5/14 P Kishor > On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro > wrote: > > I need to identify data types extracted from a > > join between multiple tables without using cross-checking table_info more > > pragmatic. > > > > Could you

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread Israel Lins Albuquerque
this! - Mensagem original - De: "P Kishor" <punk.k...@gmail.com> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Sexta-feira, 14 de Maio de 2010 11:05:43 Assunto: Re: [sqlite] data type from join multiple tables On Fri, May 14

Re: [sqlite] data type from join multiple tables

2010-05-14 Thread P Kishor
On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro wrote: > I need to identify data types extracted from a > join between multiple tables without using cross-checking table_info more > pragmatic. > Could you clarify what you really want to do? Your question is not clear at

[sqlite] data type from join multiple tables

2010-05-14 Thread Fabio Spadaro
I need to identify data types extracted from a join between multiple tables without using cross-checking table_info more pragmatic. Is there a faster way to do it? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list