Ok, it seems to work when I set the PRAGMA right away, then create a
table and insert one or two rows. I then exit the sqlite3 command
line, export my data from access to sqlite3 through an ODBC adaptor.
It is readable on the MacOSX side.
Now, I have to figure how to use it in a CoreData appl
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
Ahah, I understood "PRAGMA" as an compile option :-(
That's why point 2 was not very clear (I am new to SQLite).
I'll do this right away!
Thanks,
Alex
--
Alexander Lamb
[EMAIL PROTECTED]
On Aug 4, 2006, at 3:27 PM, Gerry Snyder wrote:
Alexander Lamb wrote:
So it is not possible to create
Alexander Lamb wrote:
So it is not possible to create a database with the legacy file format
using the command line on Windows and SQLite 3.3?
Yes it is. Reread Dr. Hipp's point (2) below.
If I understand correctly, I need to grab the latest CVS version of
SQLite to have the 3.3 format disabl
So it is not possible to create a database with the legacy file
format using the command line on Windows and SQLite 3.3?
If I understand correctly, I need to grab the latest CVS version of
SQLite to have the 3.3 format disabled by default.
The problem I see with that is that I am not a Wind
Simply using SMB (mount from my mac to the PC) then a finder copy.
--
Alexander Lamb
[EMAIL PROTECTED]
On Aug 4, 2006, at 10:31 AM, Brandon, Nicholas (UK) wrote:
I did the test with two versions of SQLite on Windows: with the
3.3 it
doesn't work (which seems more or less
normal accordi
Alexander Lamb <[EMAIL PROTECTED]> wrote:
> Hello list (I am new but searched a bit before posting).
>
> I am trying to convert an Access database on WindowsXP to an SQLite
> database to be used in a CoreData application on MacOSX (BTW, this
> task seems so generic and would help so much in tr
>I did the test with two versions of SQLite on Windows: with the 3.3 it
doesn't work (which seems more or less
>normal according to the documentation).
>However, with version 2.8, the mac can't read the file. The error is:
>Error: file is encrypted or is not a database
How have you transferred
Hello list (I am new but searched a bit before posting).
I am trying to convert an Access database on WindowsXP to an SQLite
database to be used in a CoreData application on MacOSX (BTW, this
task seems so generic and would help so much in transfering legacy
Access apps to MacOSX I am surpr
16 matches
Mail list logo