I didn't think there was an easy way but thanks for the info.

-Larry

At the moment there really isn't an override option here unless you want to create your own datasource provider (i.e. SqlDbDataSource andVfpDbDataSource) where these statements are ultimately created. The browse dialog uses a QueryInformation class (an overload option in the FillDataTable method of a business object) which is ultimately our internal version of queries that are not database specific and relies on the provider to create the actual SQL code and so forth.



I do understand your request and we will definitely add it to our "review" list. But for now there is no easy way to do this. Sorry

In version 1.4 I’ve found the capability to save fields defined in the AllFieldsList of an object that has had additional fields added in a custom fill method to be very useful. Thinking along this line I’m wondering if there is a way to dynamically modify the select statement that browsedialog uses to populate the business object. I would like the ability to join fields from other tables when browsedialog populates the BO. This is probably an enhancement request but I thought I’d ask anyway.

 

-Larry