Hi, 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" VALUES(36,80,1470395806,'','','',NULL,0.0,0,0,0,0,0.0,-Inf,0.0,-Inf,0.0,-Inf,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,NULL,4,0,''); 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. Regards, Hartwig _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
