By rfrenken - 4/2/2008
In 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'."
Is there any way to do what I described just using the properties?
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.
|
By Trent L. Taylor - 4/2/2008
Don't use the order by property. Open up the BrowseResultsLayout collection and select the field on which you want to sort. You can have the field sort ascending or decesending or just be left alone. You will only want to set this on one of the columns.
|
|