Sorry, it's a REAL problem, not just a WBO (WrongButtonPressed). I understand, that after doubleclicking on a table, a view is created to show the table-content. That view obviosly uses a field-description of the table ADRESSEN, that's stored somewhere in the odb-file. In my case, due to an earlier made table-rename, parts of that field description obviosly were not renamed properly during the actual rename process. Possibly, ooOrg.Base hang up during that renaming process, I don't remember that (it happens from time to time). Any ideas how to fix that ?
-----Ursprüngliche Nachricht----- Von: ocke.jans...@sun.com [mailto:ocke.jans...@sun.com] Gesendet: Freitag, 29. Mai 2009 11:25 An: users@openoffice.org Betreff: Re: AW: [users] ooOrg.Base: Problem with SQL-Statement - remains related to old filename after table-rename On 29.05.09 09:45, SHIMMO wrote: > Moin Ocke, > > Do you mean the order-command in the SQL-Statement? > If so, I did not enter it, at least I do not remember. ;-) The table > has only a primary key, nothing else. > The error occcurs directly after doubleclicking the table, and than I > get an empty window without data. > May be you pressed the A->Z button in the toolbar. -oj > Kind regards > guido > > > > > > -----Ursprüngliche Nachricht----- > Von: ocke.jans...@sun.com [mailto:ocke.jans...@sun.com] > Gesendet: Freitag, 29. Mai 2009 08:04 > An: users@openoffice.org > Betreff: Re: [users] ooOrg.Base: Problem with SQL-Statement - remains > related to old filename after table-rename > > Moin Guido, > > On 28.05.09 22:44, SHIMMO wrote: > >> Hi there, >> >> i have replaced a table called "OriginalTable" by doing the following >> > steps: > >> a) copying the original file to a file called "NewName" >> b) added and changed fields in "NewName" >> c) deleted "OriginalTable" >> d) renamed "NewName" to "OriginalTable" >> >> After that, I received an error code, when I tried to open the table >> to view records, the error msg is: >> >> "column not found: AdressNewName.fieldname in SQL Statement SELECT * >> FROM "Adress" ORDER BY "AdressNewName"."company" >> >> Obviously, the SQL contain ... "AdressOriginalTable"."company" >> instead of the above. >> >> > You have an ordering set on the table. When you delete that all should > work again,if not please submit an issue for this. Thanks. > > Best regards, > > Ocke > >> Any idea how I can fix that ? >> (using Version 3.10 Build 9399) >> >> Kind regards >> >> Guido >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.org For >> additional commands, e-mail: users-h...@openoffice.org >> >> >> > > > -- > Ocke Janssen Tel: +49 40 23646 661, x66661 > Dipl. Inf(FH) Fax: +49 40 23646 550 > Sun Microsystems Inc. > Nagelsweg 55 mailto:ocke.jans...@sun.com > D-20097 Hamburg http://www.sun.com/staroffice > > Sitz der Gesellschaft: > Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten > Amtsgericht Muenchen: HRB 161028 > Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel > Vorsitzender des Aufsichtsrates: Martin Haering > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org For > additional commands, e-mail: users-h...@openoffice.org > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org For > additional commands, e-mail: users-h...@openoffice.org > > -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering