Excellent. Just what I was needing! Works great. Thank you,
Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Jan 14, 2015, at 8:20 PM, "A. Razzak Memon" <[email protected]> wrote: > 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! > -- > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
