Yes, I do have this command in the eep, with true surrounded by quotes. I can change the actual data set via a button eep for the listview with the LookupWhereClause command and change the data set from say 100 rows to 50 rows, however the the sort stays "on". I.E. the last column heading clicked shows the arrow and the data is sorted by that column, even when I include the Order By statement in the new LookupWhereClause.
Is the Order By statement expected to work in the LookUpWhere Clause or am I trying to do something that is not supported. In other words can you change the sort order for the LookupListview in a a property command? When looking at the actual control code the following is what is in the VariableListView control itself: LookUpWhereClause = 'WHERE Item_Operation = '#39'RipSaw'#39' ORDER BY ReqDate ASC, Item ASC' Thanks, Bob ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 14, 2015 5:09:42 PM Subject: [RBASE-L] - RE: Clear Sort on Variable Lookup List View In the button try PROPERTY <componentid> REFRESHLIST TRUE From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 14, 2015 4:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Clear Sort on Variable Lookup List View 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
