Re: [sqlite] Schema of an attached database

2004-10-05 Thread Eddy Macnaghten 
Wow - that was fast!

Any plans for a 3.0.8?

Eddy


On Tue, 2004-10-05 at 16:44, D. Richard Hipp wrote:
> Eddy Macnaghten wrote:
> > This does not seem to work for 3.0.7
> > 
> > 
> >>Marc Pitoniak wrote:
> >>
> >>>To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') "
> >>>among other things without any success.  
> >>>
> >>
> >>PRAGMA A.table_info(T);
> > 
> 
> Fixed with check-in [2001]
> http://www.sqlite.org/cvstrac/chngview?cn=2001
-- 
Edward A. Macnaghten
http://www.edlsystems.com

Re: [sqlite] Schema of an attached database

2004-10-05 Thread D. Richard Hipp 
Eddy Macnaghten wrote:
This does not seem to work for 3.0.7

Marc Pitoniak wrote:
To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') "
among other things without any success.  

PRAGMA A.table_info(T);

Fixed with check-in [2001]
http://www.sqlite.org/cvstrac/chngview?cn=2001
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Schema of an attached database

2004-10-05 Thread Eddy Macnaghten 
This does not seem to work for 3.0.7

If you have a table named "t" in the main database, and you attach a
database that has a table named t in it as attachdb, then

pragma attachdb.table_info(t);

still seems to give the info for the table t in the main database.

Is this a bug or have I got it wrong?



On Tue, 2004-10-05 at 14:08, D. Richard Hipp wrote:
> Marc Pitoniak wrote:
> > 
> > To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') "
> > among other things without any success.  
> > 
> 
> PRAGMA A.table_info(T);
-- 
Edward A. Macnaghten
http://www.edlsystems.com

RE: [sqlite] Schema of an attached database

2004-10-05 Thread Marc Pitoniak 
Thank you very much.

-Marc


-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 05, 2004 8:09 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Schema of an attached database

Marc Pitoniak wrote:
> 
> To get the schema of a table T from A I've tried "PRAGMA table_info('A.T')
"
> among other things without any success.  
> 

PRAGMA A.table_info(T);

-- 
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Schema of an attached database

2004-10-05 Thread D. Richard Hipp 
Marc Pitoniak wrote:
To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') "
among other things without any success.  

PRAGMA A.table_info(T);
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565