Simon, On Mon, Dec 3, 2012 at 9:39 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Dec 2012, at 5:38pm, Igor Korot <ikoro...@gmail.com> wrote: > >> Simon, >> Yes, thank you. > > Great. > >> ALL, >> After recreating the table this way I had to restart sqlite console as >> otherwise >> all queries to the table were dead. >> >> Is this normal? > > Hmm. No, if you're using the standard sqlite3 shell tool you should be able > to do .read and then carry on with the new data you read in.
Yes, using standard sqlite3 shell from command prompt in Windows 7 64-bit. After .dump/.read no queries to the table in question produced output. When restarted the shell everything worked. SQLite version 3.7.14 2012-09-03 15:42:36 Enter ".help" for instructions Enter SQL statements terminated with a ";" Thank you. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users