StrataFrame Forum

BrowseDialog

http://forum.strataframe.net/Topic1060.aspx

By Scott - 5/3/2006

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

By Trent L. Taylor - 5/3/2006

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.

By Scott - 5/3/2006

Thanks for the info.

Scott

By Trent L. Taylor - 5/3/2006

Glad to help.