Bob, I utilize this PROPERTY command. However, I only use 1 ORDER BY term. I wonder if it's the second one that's fouling you.
Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Wed, 14 Jan 2015 23:17:06 +0000 (UTC) Subject: [RBASE-L] - Re: Clear Sort on Variable Lookup List View Modified your example to take into account that embedded quotes, but no success. I use a lot of Property LookupWhere clauses on this form and when they have just the Where clause, they work fine. But I cannot get the Order by to kick in. Thanks for the idea though. -Bob From:"jan johansen" <[email protected]> To:"RBASE-L Mailing List" <[email protected]> Sent:Wednesday, January 14, 2015 4:47:43 PM Subject:[RBASE-L] - Re: Clear Sort on Variable Lookup List View Bob, You can try SET VAR vLookupWhereClause TEXT = (' PROPERTY RipSawList LookupWhereClause WHERE Item_Operation = .vRipSaw ORDER BY ReqDate ASC, Item ASC') &vLookupWhereClause Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Wed, 14 Jan 2015 22:39:08 +0000 (UTC) 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
