Re: [sqlite] Extrange files

2006-03-01 Thread Nuno Lucas
On 3/2/06, Paul G <[EMAIL PROTECTED]> wrote: > From: "Nuno Lucas" <[EMAIL PROTECTED]> > > The only problem is that it can be a race condition between the > > closing of the handle and the actual delete command (because you can't > > delete an open file on win world). > > you lie! if the file is op

Re: [sqlite] Extrange files

2006-03-01 Thread Paul G
- Original Message - From: "Nuno Lucas" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 01, 2006 10:36 PM Subject: Re: [sqlite] Extrange files The only problem is that it can be a race condition between the closing of the handle and the actual delete command (because

Re: [sqlite] Extrange files

2006-03-01 Thread Nuno Lucas
On 3/1/06, Ralf Junker <[EMAIL PROTECTED]> wrote: > > >But I do not think that DOS has the ability > >to automatically delete a file when it is closed, so the > >files remain on disk after SQLite has finished with them. > > Just a thought: > > Wouldn't it possible to have SQLite thoughtfully delete

Re: [sqlite] Extrange files

2006-03-01 Thread Thomas Chust
On Wed, 1 Mar 2006, RalfJunker wrote: [...] Wouldn't it possible to have SQLite thoughtfully delete all files it creates when closing the database instead of relying on the operating system? [...] Hello, that would probably be possible, but not very efficient as you would have to keep a lis

Re: [sqlite] Extrange files

2006-03-01 Thread Ralf Junker
>But I do not think that DOS has the ability >to automatically delete a file when it is closed, so the >files remain on disk after SQLite has finished with them. Just a thought: Wouldn't it possible to have SQLite thoughtfully delete all files it creates when closing the database instead of re

RE: [sqlite] Extrange files

2006-03-01 Thread Josep Lluís Vaquer
It works You're great! Thanks a lot -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: dimecres, 1 / març / 2006 16:03 Para: sqlite-users@sqlite.org; [EMAIL PROTECTED] Asunto: Re: [sqlite] Extrange files =?iso-8859-1?Q?Josep_Llu=EDs_Vaquer?= &l

Re: [sqlite] Extrange files

2006-03-01 Thread drh
=?iso-8859-1?Q?Josep_Llu=EDs_Vaquer?= <[EMAIL PROTECTED]> wrote: > I'm running DOS, Sqlite version 3.2.8. Attached example files > The mailing list handler automatically strips attachments so they did not get through. The files you are seeing are probably temporary databases that SQLite creates

RE: [sqlite] Extrange files

2006-03-01 Thread Josep Lluís Vaquer
I'm running DOS, Sqlite version 3.2.8. Attached example files -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: dimecres, 1 / març / 2006 13:32 Para: sqlite-users@sqlite.org Asunto: Re: [sqlite] Extrange files =?iso-8859-1?Q?Josep_Llu=EDs_Vaquer?= &l

Re: [sqlite] Extrange files

2006-03-01 Thread drh
=?iso-8859-1?Q?Josep_Llu=EDs_Vaquer?= <[EMAIL PROTECTED]> wrote: > Hi, I'm new in Sqlite. > > I'm trying to develop an aplication using Sqlite and it started to work > fine. I did a relatively simple Schema and builded a few views to access > easily. The problem started when I tried to access

[sqlite] Extrange files

2006-03-01 Thread Josep Lluís Vaquer
Hi, I'm new in Sqlite. I'm trying to develop an aplication using Sqlite and it started to work fine. I did a relatively simple Schema and builded a few views to access easily. The problem started when I tried to access at one of those views (only in one of those). Each select I do to this