On 3 December 2012 19:29, Igor Korot <ikoro...@gmail.com> wrote: > Simon, > > On Mon, Dec 3, 2012 at 11:03 AM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 3 Dec 2012, at 6:53pm, Igor Korot <ikoro...@gmail.com> wrote: >> > > Here is the session: > > sqlite> CREATE TABLE test(id1 integer, id2 double); > sqlite> INSERT INTO test( 1, 1.0 ); > Error: near "1": syntax error > sqlite> INSERT INTO test VALUES( 1, 1.0 ); > sqlite> INSERT INTO test VALUES( 2, 2.0 ); > sqlite> INSERT INTO test VALUES( 3, 3.0 ); > sqlite> .timer ON > sqlite> SELECT * FROM test; > 1|1.0 > 2|2.0 > 3|3.0 > CPU Time: user 0.000000 sys 0.000000 > .output testdump.log > .dump test > sqlite> SELECT * FROM test; > CPU Time: user 0.000000 sys 0.000000 > sqlite> DROP TABLE test; > CPU Time: user 0.000000 sys 0.000000 > sqlite> .read testdump.log > > Error: incomplete SQL: 1|1.0 > 2|2.0 > 3|3.0 > sqlite> SELECT * FROM test; > CPU Time: user 0.000000 sys 0.000000 > sqlite> > > I didn't get errors when I did that with my table. Other than that its all > the same. > > > Thank you. > >>
After .dump test, add .output stdout, and try again. Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
