Thank you Larry.
From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Monday, October 19, 2009 10:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Listview and Sort << Is there any way to have the listview refresh but remember the sort that the user has selected? >> You must code for this. You can get the name of the column the user has sorted on from CURRENTSORTORDER (or something similar, I don't have R:Base open at the moment). You must then modify the LOOKUPWHERECLAUSE to change the ORDER BY to match what the user requested. The problem is that if you're using "automatic" refreshing (where you use a variable in the LOOKUPWHERECLAUSE) then you may not have an opportunity to make this change to the where clause text. I use manual updating, where I rebuild the LOOKUPWHERECLAUSE with the literal value the user entered and, at that time, I make the ORDER BY part conform to whatever the user had clicked on. I have a stored procedure that does all this automatically and will try to remember to post it to the list when I boot up my computer a little later. -- Larry This electronic message contains information from the Ohio Masonic Home, its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
