I have lost all the data from one of my tables. The fields are present, but there is no data.
If I look at the .data file in Notepad, it *looks* like the data is there, though.
The other tables appear to be intact.
Back story:
I'm an inexperienced user. I was trying to do some INSERTs into the table.
I first copied the .data file to another directory.
After trying some SQL insert commands I decided to restore the original .data file.
I closed Base, copied the original .data file back and restarted BASE.
The table had no records left.
Is there anything I can do to restore the table?
EDIT: The data was recovered by taking the four files, .data, .properties, .backup, .script and open them with HSQL Version 2.4.1 ( it is a beta at the moment ) and use SqlTool.jar to export ( extract ) the data from the one table.
Thank you Sliderule!
[Solved] Lost the data from a table
[Solved] Lost the data from a table
Last edited by ahtea on Thu Mar 15, 2018 4:18 pm, edited 4 times in total.
Apache OpenOffice 4.1.5
Windows 8.1
Windows 8.1
Re: Lost the data from a table
It is impossible for me to answer your question, unless, I can see ( look at a copy ) of your Base file ( *.odb ).ahtea wrote:I have lost all the data from one of my tables. The fields are present, but there is no data.
If I look at the .data file in Notepad, it *looks* like the data is there, though.
The other tables appear to be intact.
Back story:
I'm an inexperienced user. I was trying to do some INSERTs into the table.
I first copied the .data file to another directory.
After trying some SQL insert commands I decided to restore the original .data file.
I closed Base, copied the original .data file back and restarted BASE.
The table had no records left.
Is there anything I can do to restore the table?
Upload a copy of your Base file ( *.odb ) here, or, to a link that I can see it, such as:
https://www.mediafire.com/
Sliderule
Re: Lost the data from a table
I uploaded the .odb, .data and associated files to the mediafire, into an account just created.
Hope it was done correctly!
http://www.mediafire.com/folder/zyvwvho2ur5re/Database
Hope it was done correctly!
http://www.mediafire.com/folder/zyvwvho2ur5re/Database
Apache OpenOffice 4.1.5
Windows 8.1
Windows 8.1
Re: Lost the data from a table
ahtea:
I just sent you a PM ( Private Message ).
Sliderule
I just sent you a PM ( Private Message ).
Sliderule