Missing data table

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Missing data table

Chris B
Afternoon all,


Just joined the list.  Am a fairly long term user of SQLite Expert Personal (my version is 3.5.96.2516 - I upgraded to try version 4 a while back but the columns in the Data tab were fixed which is no good for me, I couldn't drag them wider so I went back to v3), and while I built my PC from scratch and am good with a lot of software, I'm by no means an expert when it comes to SQL or databases.


The reason for my post is to help my dad out!  We both maintain our own databases (Windows 7) - in the left hand pane of SQLite, you have the database name (basestation) and the table name (Aircraft) - I don't think this list allows snips or I'd send a screenshot but you know what it looks like.


Twice now in the last two months, the "Aircraft" table has vanished from my dad's database effectively showing no data in the data tab on the main window, but the file size has remained the same, suggesting the data is in there somewhere but without it the database is useless.  Now I know he's obviously unwittingly done something, but I'd like to know what he did, how he did it, and if there's any way to undo it, should it happen again.  After the first loss, I closed the left hand pane so he couldn't accidentally delete the table, but it's gone again so something else is amiss.  He uses a laptop with a touchpad and I know how temperamental they can be regarding a mouse swipe vs a mouse click, especially if you accidentally brush it.


Yes we've backed up the database, but I'd like to prevent this from happening in the first place, or at least be able to undo it and get the table back.


If there's anything I've left out please ask, and many thanks for any help with this.

Chris
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Missing data table

Simon Slavin-3


On 16 Dec 2017, at 1:51pm, Chris B <[hidden email]> wrote:

> Twice now in the last two months, the "Aircraft" table has vanished from my dad's database effectively showing no data in the data tab on the main window, but the file size has remained the same, suggesting the data is in there somewhere but without it the database is useless.

Hello, Chris.

Your problem is actually with the program called SQLite Expert Personal.  This is not written by the same people who wrote SQLite.  It is just a program which uses SQLite format.  Most of the people reading this list have never used that program.

You may find you get better help from the sources listed here:

<http://www.sqliteexpert.com/forum/YaBB.pl>
<http://www.sqliteexpert.com/support.html>

On the other hand, you may be lucky, and someone familiar with your program may be reading this list.

If you get no help in the above places, we may be able to help by telling you how to rescue the data from your database and write it to a text file.  But you should try people who understand your program first.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Missing data table

Jean-Christophe Deschamps-3
In reply to this post by Chris B
At 14:51 16/12/2017, you wrote:

>Just joined the list.  Am a fairly long term user of SQLite Expert
>Personal (my version is 3.5.96.2516 - I upgraded to try version 4 a
>while back but the columns in the Data tab were fixed which is no good
>for me, I couldn't drag them wider so I went back to v3), and while I
>built my PC from scratch and am good with a lot of software, I'm by no
>means an expert when it comes to SQL or databases.
>
>
>The reason for my post is to help my dad out!  We both maintain our
>own databases (Windows 7) - in the left hand pane of SQLite, you have
>the database name (basestation) and the table name (Aircraft) - I
>don't think this list allows snips or I'd send a screenshot but you
>know what it looks like.
>
>
>Twice now in the last two months, the "Aircraft" table has vanished
>from my dad's database effectively showing no data in the data tab on
>the main window, but the file size has remained the same, suggesting
>the data is in there somewhere but without it the database is
>useless.  Now I know he's obviously unwittingly done something, but
>I'd like to know what he did, how he did it, and if there's any way to
>undo it, should it happen again.  After the first loss, I closed the
>left hand pane so he couldn't accidentally delete the table, but it's
>gone again so something else is amiss.  He uses a laptop with a
>touchpad and I know how temperamental they can be regarding a mouse
>swipe vs a mouse click, especially if you accidentally brush it.

I'm as well a (very) long-term user of Expert (a completely distinct
product from what the SQLite dev team maintains and offers for free).

When you open Expert and [re]open your database, you should see a +
sign in the DB tree (left pane) showing you that the DB contains
elements (tables and vues). When you hit this + sign, it chenges to a -
sign and the tree expands to list tables and vues; then you can select
one of them to see its contents in the Data tab.

Since you seem to say that this is something having occured twice I
believe the problem is just misuse of the tree panel.

If you have (or your dad has) explicitely selected one table and hit
Del key, a message box popped up to prompt you for confirmation of
removal of the table. If a table has been deleted it's no longer
available from Expert nor any SQLite DB manager. I believe it can still
be recovered by technical means unless the file has been changed later,
e.g. by attempting to recreate a table.

As Simon advised you can ask Expert's author for support, even if you
use the free version.

JcD

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users