On Fri, Jan 16, 2009 at 09:43:36AM +0100, Christophe Leske wrote:
> sqlite> .o cl1.sql
^^
This says: send output of queries to a file called "cl1.sql".
> sqlite> .dump cl1%
And this says: dump the named table.
> sqlite> select * from cl1;
And the output of this will still go
> After you complete your ".dump" do:
>
> .output stdout
>
Ok, that was stupid, my apologies.
Yet somehow this used to work i think...
Still, when rereading the dumped table, it does not reread the values
correctly for the rtree table.
I am sorry, I must go now, I can provide further
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
On Jan 16, 2009, at 3:43 AM, Christophe Leske wrote:
>
> Do you want me to mail you the corrupted database for further
> inspection? I also understand that this is not the right place for
> bugreports eventually.
No. Email me the original, uncorrupted database and instructions for
how to
> 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
> 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
On Jan 15, 2009, at 12:43 PM, Christophe Leske wrote:
> Hi,
>
> if my findings are not mistaken, then the commandline executable of
> the
> new version has some serious problems:
>
> I have a database (which seems correct so far) from which I would like
> to dump a table called "cl1" which is
Hi,
if my findings are not mistaken, then the commandline executable of the
new version has some serious problems:
I have a database (which seems correct so far) from which I would like
to dump a table called "cl1" which is a virtual table using an rtree:
sqlite> .o cl1.sql
sqlite> .d cl1
8 matches
Mail list logo
