Apache OpenOffice (AOO) Bugzilla – Issue 114527
Database does not show updated mysql data
Last modified: 2013-01-29 21:47:34 UTC
I created a query in myquery.odb, which connects to a mysql database (via MySQL Connector). When I insert a new entry in mysql (via phpmyadmin) and I do a refresh in my OpenOffice query, the new entry does not show up in the query. I even did a restart of my computer (Ubuntu 10.04) and the entry does not show in the query, but it shows up in the table data in my myquery.odb file and in mysql. So the problem: The query I created within myquery.odb does not get updated with the new entries even after system restart. As you see on the screenshot, the las entry in the table is 1002081 and the last entry in the query is 1002090, the latest entry is missing.
Created attachment 71711 [details] Screenshot of the lacking entry in query compared to table
what's the SQL statement defining the query?
This is one example (works with nearly all statements) SELECT `rechnungen`.`Rechnungnr`, `rechnungen`.`Kundennr`, `rechnungen`.`Datum`, `rechnungen`.`Betrag`, `rechnungen`.`Leistung`, `kundendaten`.`Vorname`, `kundendaten`.`Nachname`, `kundendaten`.`Titel`, `kundendaten`.`Strassse`, `kundendaten`.`HausStiegeTuer`, `kundendaten`.`PLZ`, `kundendaten`.`Ort`, `kundendaten`.`Telefon`, `kundendaten`.`Telefax`, `kundendaten`.`Firmenname`, `kundendaten`.`Anrede` FROM `Firma`.`kundendaten` `kundendaten`, `Firma`.`rechnungen` `rechnungen` WHERE ( `kundendaten`.`Kundennr` = `rechnungen`.`Kundennr` )
At the risk of stating the obvious: 1) the WHERE clause may be excluding the last record from the query even though it appears in the table, or 2) the query might be being performed on a different, but similar, table, or 3) the query might be performed on a different, but similar, database (ie is the `Firma` database the one appearing in the table window?) I sometimes have two similar versions of the same table or database on a single host or two versions of the same database on two different hosts. It is remarkably easy to access the "wrong" one and become hopelessly confused.