Re: [sqlite] Missing data table

[Jean-Christophe Deschamps]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Missing data table

[Simon Slavin]

On 16 Dec 2017, at 1:51pm, Chris B  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:




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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users