Hi Guido,
On 29.05.09 12:47, SHIMMO wrote:
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 ?
Not at the moment. Could you please submit an issue for this one with a
description how to reproduce it? Thanks.
Best regards,
Ocke
PS: Which version of OOo do you use?
-----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
--
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