InstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netWed, 07 Jan 2009 14:53:54 GMT20http://forum.strataframe.net/Topic1060-7-1.aspxGlad to help.Wed, 03 May 2006 15:20:26 GMTTrent L. Taylorhttp://forum.strataframe.net/Topic1060-7-1.aspxThanks for the info.</P><P>ScottWed, 03 May 2006 15:11:54 GMTScotthttp://forum.strataframe.net/Topic1060-7-1.aspxScott,</P><P>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.</P><P>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.</P><P>Hope this helps.Wed, 03 May 2006 14:59:42 GMTTrent L. Taylorhttp://forum.strataframe.net/Topic1060-7-1.aspxI 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.</P><P>Thanks</P><P>ScottWed, 03 May 2006 14:38:03 GMTScott