Dynamic SQL Search


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

Heinz Böttrich
Heinz Böttrich
StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)
Group: Forum Members
Posts: 2, Visits: 3
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

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