Conference abbott::teamlinks_windows

2045.0. "Sort Order and PAB" by OASS::ANDRES_B () Wed Mar 12 1997 15:07

    A site is using the PAB and adding an additional field of Location.
    
    The PAB is set to sort on the location field.  However, under field
    they would like it to then be sorted on last name.  The PAB does not
    have a primary and secondary sort.  The PAB is being sorted on location
    properly but the entries for that location seem to have a strange
    order.
    
    This site uses the PAB as a corporate type directory and each time the
    user starts TeamLinks a copy of a1mailpb.dat is copied from the server
    to each users PC.  This file is usually in location order and then last
    names under each location are alphabetized.  When the user starts
    TeamLinks and the file is copied and the PAB selected the Location order 
    is correct the order for the entries does not appear to have a pattern.
    
    I created a new PAB with 3 different Locations and 2 names under
    one location 3 under another and 4 under another.  When the PAB was
    started I selected to have it sort by location.  The location sort was
    fine but then how is the order determined under the sort field?
    
    Beth
    

The entries are read in the order that they were last saved. The order 
saved will reflect the last sort that was done. For instance if you sort on 
column 1 then save the list will be saved in the that order if you then 
sort by column 2 and save it will now be saved in that order. The reason 
that this is important is that when it is sorting a different way it reads 
the data in record sequential order based onthe last save and adds it to a 
sorted multi column list box. The list box sorts the entries as it comes in  
and I think puts additional exact matching entries at the end of the 
existing records but it may be at the beginning. So if the lsat save was:

Col1	Col2	
1	a
2	b
3	a
4	b
5	a
6	b
9	a <-----|---Note that these are out of order
8	b       |
7	a <-----|
0	b
 
And is now sorted by col2
1	a	
3	a	
5	a	
9	a <----|Note that the order  doesn't change. 	
7	a <----|	
2	b	
4	b	
6	b	
8	b	
0	b	

I am guessing at wht the multi column list control does with matching 
entries but the method is still the same. Other columns are not looked at 
but are added to the control in the order they are read when the PAB is 
loaded. 

Cheers, 
jal