I issued the following commands:
echo .dump | sqlite3 Database.sldb > D.sldb
sqlite3 -init D.sldb NewDatabase.sldb
Unfortunately, reading the SQL file produced the following error:
Error: near line 56721: no such column: Inf
The corresponding SQL command is:
INSERT INTO "Flights"
OK, it seems to be that the column values are not really correct (-Inf) but I
would still like to do the conversion. Is there a command/trick in sqlite3 that
makes it work?
A workaround is of course to use a text editor and try to find and replace all
occurrences of Inf or -Info.
sqlite-users mailing list