StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » BrowseDialog

BrowseDialog

Scott — Wed, 03 May 2006 15:20:26 GMT

I noticed that there is a OrderBy property on the Browsedialog but was unable to find anything about it in the help file. When I set its value the order of the results do not change. How is the property used.

Thanks

Scott

RE: BrowseDialog

Trent L. Taylor — Wed, 03 May 2006 15:20:26 GMT

Glad to help.

RE: BrowseDialog

Scott — Wed, 03 May 2006 15:11:54 GMT

Thanks for the info.

Scott

RE: BrowseDialog

Trent L. Taylor — Wed, 03 May 2006 14:59:42 GMT

Scott,

The OrderBy property only applies to OLE DB databases. For example, if you have a business object that is browsing a Visual FoxPro database, it requires an ORDER BY clause for a TOP x statement. Without this statement FoxPro does not know how to gather the records.

The reason your results did not change is because the initial sort is determined by the SearchColumns by setting one of the fields sort direction.

Hope this helps.