Well, it didn't seem to work when I copied the file to MacOSX. It
said (after accepting to go into command line mode) "invalid file
format".
I don't have an intel box to test now, so I will try again on monday
at the office.
My other option is to save the data in 2.8 format and convert from
Alexander Lamb <[EMAIL PROTECTED]> wrote:
> Well, I am afraid it didn't work.
>
> Somehow, the legacy_file_format info is not "sticky".
>
The "legacy_file_format" pragma does not appear to be
sticky, but it is. The value reported back by
PRAGMA legacy_file_format
is incorrect. But the le
Alexander Lamb wrote:
Well, I even tried to insert a row in the table. The table contains
the data. The file on the disk is 2K length. The PRAGMA commands tells
me I am in legacy file format mode (1) but when I quit then
return, I am back to 0!
I just tried the same thing and got th
Alexander Lamb uttered:
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 int
Alexander Lamb uttered:
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 th
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 PRAGM
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
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;
then
CREATE TABLE TEST (id int);
if I then quit and return to sqlite3 and attach the database I jus
8 matches
Mail list logo