Re: [dba-dev] Ghost records

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germany
Hi Andrew, >> You might want to take into account what I just added to issue 69995 - >> basically, we all who we tampered with this issue overlooked the obvious >> - the table had a filter associated with it, thus it didn't display all >> records. If you remove this filter, the record count is per

Re: [dba-dev] Ghost records

2007-08-24 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hello Andrew, I'll open / update all these this weekend. You might want to take into account what I just added to issue 69995 - basically, we all who we tampered with this issue overlooked the obvious - the table had a filter associate

Re: [dba-dev] Ghost records

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germany
Hello Andrew, > I'll open / update all these this weekend. You might want to take into account what I just added to issue 69995 - basically, we all who we tampered with this issue overlooked the obvious - the table had a filter associated with it, thus it didn't display all records. If you remove

Re: [dba-dev] Ghost records

2007-08-24 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew, Should I change the summary on the current Issue or close that one and open another? Please add your findings to the issue (and change the summary if appropriate) , I think it still describes pretty good what this all is abo

Re: [dba-dev] Ghost records

2007-08-23 Thread Frank Schönheit
Hello Marc, >> After compacting, it is now 8.88 K > This is what I was hoping for when I copied the table definitions and > deleted the old tables. Would it make sense to add this as a menu option? Yes. Not sure if there already is an issue requesting this, though. Ciao Frank -

Re: [dba-dev] Ghost records

2007-08-23 Thread Marc Blakely
andrew wrote: Marc Blakely wrote: Drew, I've recently run into a similar situation with a database I'm developing for work. There are two tables which I import records into from a csv file via Calc. I delete the previous records from each table prior to the import (actually append, sinc

Re: [dba-dev] Ghost records

2007-08-23 Thread Frank Schönheit - Sun Microsystems Germany
Hi Andrew, > Should I change the summary on the current Issue or close that one and > open another? Please add your findings to the issue (and change the summary if appropriate) , I think it still describes pretty good what this all is about. This sounds serious enough to have a deeper look into

Re: [dba-dev] Ghost records

2007-08-23 Thread andrew
Marc Blakely wrote: Drew, I've recently run into a similar situation with a database I'm developing for work. There are two tables which I import records into from a csv file via Calc. I delete the previous records from each table prior to the import (actually append, since the structure d

Re: [dba-dev] Ghost records

2007-08-23 Thread Marc Blakely
andrew wrote: Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew, In one particular table there are, what appear to be deleted records that do not show in a dataview window. They are not returned if one just queries the single table. But if one uses that table in a join, then the

Re: [dba-dev] Ghost records

2007-08-23 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew, In one particular table there are, what appear to be deleted records that do not show in a dataview window. They are not returned if one just queries the single table. But if one uses that table in a join, then they records are ret

[dba-dev] Ghost records

2007-08-22 Thread Jahn, Ray \(R.\)
Dear Drew: I am curious about the nature about this issue. Would it still occur by using HSQLDB in stand alone mode (without OO Base)? In other words: * extract the database elements out of the *.odb (zip format) * use SQL CUI of HSQLDB to examine the table "checkout" in the extracted database

Re: [dba-dev] Ghost records

2007-08-22 Thread Frank Schönheit - Sun Microsystems Germany
Hi Andrew, > In one particular table there are, what appear to be deleted records that do > not show in a dataview window. > They are not returned if one just queries the single table. > But if one uses that table in a join, then they records are returned. > ... Strange - never heard of this, nev

Re: [dba-dev] Ghost records

2007-08-21 Thread andrew
and one final interesting thing. I created a new database using StarOffice. Dragged the tables from the old database to the new empty one. In the new database I have a CheckOut table with - you guessed it. 109 records. All the data was restored. A feature? -

Re: [dba-dev] Ghost records

2007-08-21 Thread andrew
A quick follow up on this. I received this message from the user: "Well, I did have the system crash several times while I was experimenting with stuff. The weirdest problem I had was yesterday after I deleted some of the test data from the CheckOut table, and tried to e-mail the database to

[dba-dev] Ghost records

2007-08-21 Thread Andrew Jensen
I am running into a problem and curious if anyone has seen it. Received a Base database via email. The database file was created using OOo2.2 under MS Vista. In one particular table there are, what appear to be deleted records that do not show in a dataview window. They are not returned if one j