I tried with just one column but no success. I need the two anyway. I know I can probably go to the old "create a temp view, drop it and redefine it with the sort parameters", but I am wanting to try to stay within the form control structure where possible. The WHERE works great and I was hoping I could control the Order By as well.
-Bob ----- Original Message ----- From: "jan johansen" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 14, 2015 5:21:32 PM Subject: [RBASE-L] - Re: Clear Sort on Variable Lookup List View 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 ----- Original Message ----- 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 <blockquote> -----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 </blockquote>
