Doug: Something that Javier said made me think of something too. I thought when you do a PROPERTY TABLE ... REFRESH, it repeats however the form was brought up in the first place. So if you did an EDIT USING form WHERE ... ORDER BY yourcolumn ASC, wouldn't that second "refresh" restore the ascending sort?
Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Mon, Sep 6, 2021 12:20 pm Subject: RE: [RBASE-L] - PROPERTY SORTASC doesn't <!--#yiv1546384673 _filtered {} _filtered {}#yiv1546384673 #yiv1546384673 p.yiv1546384673MsoNormal, #yiv1546384673 li.yiv1546384673MsoNormal, #yiv1546384673 div.yiv1546384673MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv1546384673 a:link, #yiv1546384673 span.yiv1546384673MsoHyperlink {color:blue;text-decoration:underline;}#yiv1546384673 a:visited, #yiv1546384673 span.yiv1546384673MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv1546384673 p.yiv1546384673msonormal0, #yiv1546384673 li.yiv1546384673msonormal0, #yiv1546384673 div.yiv1546384673msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv1546384673 span.yiv1546384673EmailStyle19 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv1546384673 .yiv1546384673MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv1546384673 div.yiv1546384673WordSection1 {}-->I use this construct with Enhanced Grids: -- Sort table by DistrictPROPERTY vciKCMOFeaturesBase SortASC 'CouncilDistNo'RETURN I primarily use ascending sorts but I believe “SortDesc” should work the same way; also, I always use columns names rather than column number, this way I don’t have to check with which column I am working . Have you tried removing one or both “REFRESH” lines?One more thing, be sure your component ID does not have a blank at the end. When you paste into the component ID box, the Editor adds a blank at the end and it is/was a nightmare to find it…ask me how I know. I have not checked recently and I am not sure it still does this. You ca also try: PROPERTY TABLE YourTableName 'RestoreOrderBy' To restore it to the original sort and then run your sort PROPERTY command. Lastly, try running the sort command line twice in a row, you never know what might happen. 😊 Javier, Javier Valencia, PE913-915-3137 From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Sunday, September 5, 2021 5:17 AM To: R:Base List <[email protected]> Subject: [RBASE-L] - PROPERTY SORTASC doesn't PROPERTY <Component ID> SORTASC '0' sorts Descending instead of Ascending - see screen shot of TRACE below. The object is an Enhanced DB Grid, ComponentID - EDBG_PT, on a temp table, tSHPT. '0' is zero, not alpha Oh. Using column name instead of index - same results. True of other columns - they sort DESC instead of ASC. Manually clicking column header sorts ASC/DESC as expected Form got trashed? Any suggestions? RB X.5E 20812 TIA, Doug | | This email has been checked for viruses by Avast antivirus software. www.avast.com | -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/5a0395fb-9401-32dc-29da-17c9b86a00c3%40wi.rr.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAEYyaJ5B86FGsJrE8Z0udbEBAAAAAA%3D%3D%40vtgonline.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/611595208.2509986.1630952102795%40mail.yahoo.com.
