Re: Form Name sorting inconsistency
Greetings,
I discovered the key to sorting these lists is to close the database and
reopen it. The lists are only sorted when something is added to the list
or the database is opened. Just switching to another list and back does
not re-sort it.
It is a work-around. My immediate problem is solved.
Girvin
On 10/15/22 4:08 PM, Girvin Herr wrote:
Here is an addendum:
Since I posted this thread, I copied a form from another database and
the new form was put at the bottom of the list, even though it should
have gone in somewhere in the middle if sorted (unless I switched
universes and in this universe, P comes after V). That implies these
names are in some sort of chronological order of creation, rather than
sorted. If not sorted, is there a way to manually edit where these
names are stored in order to manually sort them?
Thanks.
Girvin
On 10/15/22 12:12 PM, Girvin Herr wrote:
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order
to force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as
this snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I
was hoping the dash would force the listing to go to the head of the
list, before any lower case entries.
Is there any way to correct this and get it to sort properly, or is
this a bug?
Thanks.
Girvin
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Form Name sorting inconsistency
Here is an addendum:
Since I posted this thread, I copied a form from another database and
the new form was put at the bottom of the list, even though it should
have gone in somewhere in the middle if sorted (unless I switched
universes and in this universe, P comes after V). That implies these
names are in some sort of chronological order of creation, rather than
sorted. If not sorted, is there a way to manually edit where these names
are stored in order to manually sort them?
Thanks.
Girvin
On 10/15/22 12:12 PM, Girvin Herr wrote:
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order
to force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as this
snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I
was hoping the dash would force the listing to go to the head of the
list, before any lower case entries.
Is there any way to correct this and get it to sort properly, or is
this a bug?
Thanks.
Girvin
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Form Name sorting inconsistency
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order to
force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as this
snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I was
hoping the dash would force the listing to go to the head of the list,
before any lower case entries.
Is there any way to correct this and get it to sort properly, or is this
a bug?
Thanks.
Girvin
