Confirmed but open still opens the textfile, i wish it cancelled that as
well.
There is no use to an open textfile for sqlite.
----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 22, 2005 5:54 PM
Subject: Re: [sqlite] Why can i open a textfile?
On Mon, 2005-08-22 at 08:42 -0700, Clark Christensen wrote:
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> ...
> SQLite never "blows away" a file that is not a database.
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
Sorry to report this doesn't seem to be the case. At least
not under Windows. Using v3.2.2, I can "sqlite3 junk.txt",
then "create table junk (a,b)", and the text file becomes a
SQLite3 database :-(
FWIW, junk.txt contained several lines of text before
becoming a database.
See http://www.sqlite.org/cvstrac/tktview?tn=1370
The problem has been fixed in version 3.2.3.
--
D. Richard Hipp <[EMAIL PROTECTED]>
