StrataFrame Forum

Dynamic SQL Search

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

By Heinz Böttrich - 11/5/2006

Hi,



is it possible to implement a dynamic SQL-Search to the SF Maintenance Form. I Don´t want to use the Browsedialog, because my customers are used to search directly in the "Maintenance" Form. And it is important for me to search for all the fields on the Form.



regards Heinz
By Trent L. Taylor - 11/6/2006

If you already know what you are wanting to search on and do not want to go through the BrowseDialog, it may just be easier for you create a Fill method that populates your business object the way that you would like.

One of other option is calling the BrowseDialog and programmatically executing the search.  If you look in the documentation, you will see more details about the BrowseDialog.  But you can set the initial search values programmatically and then force the browse to search and appear when the results when displayed to the end-user.

For example:

Me.BrowseDialog1.SearchFields.Item("MyField").InitialValue = "MyValue"
Me.BrowseDialog1.ShowDialog(True)