Browse Dialog OrderBy descending?


Author
Message
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.


rfrenken
rfrenken
StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)
Group: StrataFrame Users
Posts: 1, Visits: 17
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search