Well, sorry, but I did exactly that:
1) When I do the PRAGMA command the file is created (I can see it
appearing in the explorer)
2) After the create table, if I do PRAGMA legacy_file_format; I
indeed receive "1" as an answer.
However,
I ".quit" then go back into the database and ask PRAGMA
legacy_file_format; it returns "0".
Once I quit, it "reverts" to 0??
So, if I have to issue a PRAGMA legacy_file_format=ON; each time I
enter sqlite, I have a problem when I access the database through
ODBC. I have no way to issue that PRAGMA command!
Am I correct in my reasonning?
--
Alexander Lamb
[EMAIL PROTECTED]
On Aug 4, 2006, at 4:31 PM, [EMAIL PROTECTED] wrote:
Alexander Lamb <[EMAIL PROTECTED]> writes:
1. (*) text/plain
Well, I am afraid it didn't work.
Somehow, the legacy_file_format info is not "sticky".
I did:
sqlite3
then in command mode:
PRAGMA legacy_file_format=ON;
then
ATTACH "d:\mydb.db" AS mydb;
In order to have done an ATTACH, the database had to have already
existed.
That's too late. Instead, ensure that mydb.db *does not exist*,
and then do:
sqlite3 d:\mydb.db
PRAGMA legacy_file_format=ON;
CREATE TABLE TEST (id INTEGER);
The next time you then access the file, it will have the proper
format.
Derrell