At 05:39 PM 1/14/2015, [email protected] wrote:
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.
Sort
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.
Bob,
As mentioned in my previous e-mails, there are many surprises in the
latest and greatest version and update of R:BASE eXtreme 9.5 (32/64),
Update 5, Build: 9.5.5.20109.
It is perfect timing to document the un-documented PROPERTY to reset
the current sort and reset the dataset to its original sort defined
in the WHERE clause.
Here's how:
Place an Enhanced Speed Button control with the Caption 'Reset' and
use the following code as "On Click EEP":
-- Reset current sort and use the original sort in WHERE Clause
-- Author: A. Razzak Memon
-- Un-Documented PROPERTY Command for Variable Lookup List View
-- Date Created: January 14, 2015
-- Last Updated:
PROPERTY RipSawList COLUMNTOSORT '-1'
PROPERTY RipSawList REFRESHLIST 'TRUE'
RETURN
And, that's all there is to it!
Notice the property COLUMNTOSORT '-1'. That's the key to RESET the
altered sort and bring the dataset back to its original state as
defined in the WHERE Clause for Variable Lookup List View control.
Let me know if you need a sample application to illustrate the use
of PROPERTY <VariableLookupListViewCompID> COLUMNTOSORT '-1' command.
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
