On Jan 16, 2009, at 3:42 AM, Christophe Leske wrote:
>
>> Try instead:
>>
>> .dump cl1%
> Apparently, this doesn´t help either. Once I tried to export the
> table, the application refuses to show the entries in the table.
>
> The database i am opening here is correct, it holds data in cl1
> prior to opening it for this step here:
>
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
>
> C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3
> countries2.db
> SQLite version 3.6.10
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .o cl1.sql
> sqlite> .dump cl1%
> sqlite> select * from cl1;
> sqlite>
>
> Also, a .show statement returns nothing either. It seems as if the
> database does simply not exist anymore.
>
Everything is still working normally. But the output is all going
into the file named "cl1.sql", as you requested on the first line.
After you complete your ".dump" do:
.output stdout
To cause output to go to the screen again.
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
