InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumWed, 08 Jul 2026 17:40:23 GMT20http://forum.strataframe.net/FindPost15329.aspxIn a spot where I'm using a Browse Dialog and had the OrderBy property set to a field (and that was working fine) I realized I really need to sort it by that field descending but if I just change OrderBy from "myfield" to "myfield desc" I get the error "Invalid column name 'myfield desc'."<br> <br> Is there any way to do what I described just using the properties?<br> <br> Looks like the BrowseDialog ignores the Order By in the Buisiness object's Fill too but I kind of expected that since it looks like the BrowseDialog dynamically builds it's own Select.Wed, 02 Apr 2008 13:32:04 GMTrfrenkenhttp://forum.strataframe.net/FindPost15338.aspxDon't use the order by property.&nbsp; Open up the&nbsp;BrowseResultsLayout collection and select the field on which you want to sort.&nbsp; You can have the field sort ascending or decesending or just be left alone.&nbsp; You will only want to set this on one of the columns.</P><P><IMG src="http://forum.strataframe.net/Uploads/Images/81790a73-aaf6-42ba-8c93-3abc.png">Wed, 02 Apr 2008 13:32:04 GMTTrent L. Taylor