Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Simon Slavin
On 20 Oct 2010, at 12:11pm, Frank Millman wrote: > I am writing a generalised business/accounting application, which is > multi-company. I have got it working using MS SQL Server and PostgreSQL as > databases, and now I want to add sqlite3 as a third option, for small > single-user systems and

Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Frank Millman
Drake Wilson wrote: > > Quoth Frank Millman , on 2010-10-20 > 11:47:06 +0200: > > Ok, thanks. > > > > Is there any chance of it being considered for a future release? > > Search http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq for "foreign > key". > Thanks, Drake. I

Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Drake Wilson
Quoth Frank Millman , on 2010-10-20 11:47:06 +0200: > Ok, thanks. > > Is there any chance of it being considered for a future release? Search http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq for "foreign key". > Frank ---> Drake Wilson

Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Dan Kennedy
On Oct 20, 2010, at 4:47 PM, Frank Millman wrote: > Dan Kennedy wrote: >> >> On Oct 20, 2010, at 3:59 PM, Frank Millman wrote: >> >>> Hi all >>> >>> I am using SQLite 3.7.2 on Fedora 10. >>> >>> I have multiple databases, which I can access concurrently >> by using >>> the >>> 'attach' command,

Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Frank Millman
Dan Kennedy wrote: > > On Oct 20, 2010, at 3:59 PM, Frank Millman wrote: > > > Hi all > > > > I am using SQLite 3.7.2 on Fedora 10. > > > > I have multiple databases, which I can access concurrently > by using > > the > > 'attach' command, and then referring to each table using > >

Re: [sqlite] Foreign key on different database - possible?

2010-10-20 Thread Dan Kennedy
On Oct 20, 2010, at 3:59 PM, Frank Millman wrote: > Hi all > > I am using SQLite 3.7.2 on Fedora 10. > > I have multiple databases, which I can access concurrently by using > the > 'attach' command, and then referring to each table using > 'database.tablename'. It works well. > > Now I want to

[sqlite] Foreign key on different database - possible?

2010-10-20 Thread Frank Millman
Hi all I am using SQLite 3.7.2 on Fedora 10. I have multiple databases, which I can access concurrently by using the 'attach' command, and then referring to each table using 'database.tablename'. It works well. Now I want to create a foreign key constraint where the parent table is in one