Thanks, but I am needing for the user to be able to clear the sort. I.E. the list view comes up sorted by Required Date and then by Item. They click the column Vendor and sorts the data by Vendor. Now they need to go back to Required Date, Item.
I placed a "Reset" button and used the below property commands, but the sort does not clear. -Bob ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 14, 2015 4:43:19 PM Subject: [RBASE-L] - RE: Clear Sort on Variable Lookup List View On the properties tab there is a checkbox for “column sort” Dennis McGrath From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 14, 2015 4:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Clear Sort on Variable Lookup List View 9.5 latest update Variable Lookup Listview Click a column header and it sorts by that column is ascending order. Click a second time and it sorts in descending order. Each time showing a corresponding Up or Down arrow on the column header. How do you remove the sort? I tried: Property RipSawList LookupWhereClause + 'WHERE Item_Operation = .vRipSaw ORDER BY ReqDate ASC, Item ASC' Property RipSawList refreshlist 'true' to put it back in the original sort order but this does not work. This is the original parameters in the property of the LookupListView. The Up or Down arrow stays on the column header and the sort is still applied after the above has been executed. Do I have a syntax error that I am not seeing? I could find no Property command to Clear the column sort for the Lookup List View. Thank you, Bob
