Dobermann

I cannot seem to find a way to have the category values sorted in apha order. It seems to just list them in the order entered. Rather silly, not to mention it slows down data entry.

Just for clarification, category values are not the field values that you can simply sort by clicking on the column heading. These are the values you find in the drop down box. :)

Cheers,
Dobermann

__________________
This vehicle is unlocked and the keys are under the Dobermann...

AKAJohnDoe

I'm not sure I quite understand.

I have a number of ListPro lists that I've created that I did not include a category field in their definitions.

If I'm not mistaken, in ListPro terminology, while it is possible to create a field with the name CATEGORY, that category is actually a field type. And therefore, any field with the type of category automatically tracks the values that have been input into the records for that field and dynamically maintains a drop-down box of those categories, or types.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

harleyxlc

Mine sort automatically and I didn't do anything, it just happens :)

Dobermann

Originally Posted by harleyxlc

Mine sort automatically and I didn't do anything, it just happens :)

Show off! :)

Lucky you!

__________________
This vehicle is unlocked and the keys are under the Dobermann...

Dobermann

Originally Posted by AKAJohnDoe

I'm not sure I quite understand. I have a number of ListPro lists that I've created that I did not include a category field in their definitions. If I'm not mistaken, in ListPro terminology, while it is possible to create a field with the name CATEGORY, that category is actually a field type. And therefore, any field with the type of category automatically tracks the values that have been input into the records for that field and dynamically maintains a drop-down box of those categories, or types.

For me, an ole time dBase programmer, using ListPro terminology is awarkward, as it is not true database terminology. They call the values in a typical drop down box "category values". Really they are drop down values.

Let's see if I can better explain it. In my dropdown that is self propagating from data values entered, rather than previous values being shown in alpha order, they are apparently shown in order entered. For example, the field has values of "banana", "apple", "pear", "orange" and "plum". Rather than listing them in the drop down as, "apple", "banana", "orange", "pear" and "plum", it lists them just as first typed.

It has this problem only with character fields. If it is a numeric field, it automatically lists them in numeric order.

As an update, since I closed the file last night and just reopened it today, it now lists them in alpha order. So apparently it requires a file close to have the alpha fields drop down values properly sorted. This is a program bug.

Thanks for trying to help. Maybe the makers of ListPro will fix this.

Cheers,
Dobermann

__________________
This vehicle is unlocked and the keys are under the Dobermann...

coolabah

Originally Posted by Dobermann

For me, an ole time dBase programmer, <<snip>> As an update, since I closed the file last night and just reopened it today, it now lists them in alpha order. So apparently it requires a file close to have the alpha fields drop down values properly sorted. This is a program bug. Thanks for trying to help. Maybe the makers of ListPro will fix this. Cheers, Dobermann

Not sure if it is a bug ?
I find that the last chosen item appears at the top of the list the next time I open the drop-down combobox- have you noticed this behaviour ?

AKAJohnDoe

Originally Posted by Dobermann

For me, an ole time dBase programmer, using ListPro terminology is awarkward, as it is not true database terminology.

As a former IMS, System/2000, DB2, and SQL/Server applications, DBA, and systems guy, I would agree that it is not database terminology; however, ListPro does not purport to be a database, either.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Dobermann

Originally Posted by AKAJohnDoe

As a former IMS, System/2000, DB2, and SQL/Server applications, DBA, and systems guy, I would agree that it is not database terminology; however, ListPro does not purport to be a database, either.

So very true, but it can be used as a flat table. But using a listbox, I would expect it to organize it after each use (see below post for further details).

Cheers,
Dobermann

__________________
This vehicle is unlocked and the keys are under the Dobermann...

Dobermann

Originally Posted by coolabah

Not sure if it is a bug ? I find that the last chosen item appears at the top of the list the next time I open the drop-down combobox- have you noticed this behaviour ?

Yes, exactly. This might be considered an "aid", but watch what it does when you add several new values. Each new value is put at the top of the list. Add 10 or 15 different new values, and look at what you have. You now have a disorganized list with the last thing entered being up top and the next 9 or 14 values being listed below it in no order at all except what it was entered in.

The only way to make it reorder the values is either delete or add one of the values in Category View or else close and reopen the list. Either one forces a reorganization.

It's not the best list box handling around. Fortunately, at least it does respond to first letters typed to bring up possible matches and save you from having to scroll through all the disorganized entries.


Cheers,
Dobermann

__________________
This vehicle is unlocked and the keys are under the Dobermann...