BrowseDialog - Adding a WHERE clause

Aaron Young — Wed, 29 Apr 2009 09:43:58 GMT

Hi,

I know you can add a custom WHERE clause in a BrowseDialog's Searching event when you know the specific values, ie.

WHERE my_Car IN (0,1,2)

But can you do this?

WHERE my_Car IN (SELECT carid FROM myCars)

Is this possible?

Thanks,

Aaron

RE: BrowseDialog - Adding a WHERE clause

Trent L. Taylor — Wed, 29 Apr 2009 09:43:58 GMT

Yup. In the most recent version of the BrowseDialog in the latest update, you can go at this two different ways. There are two new properties called OverrideSearchTableName and OverrideSearchTableSchema which allows an alternate table or view to be used instead of the underlying BO table name. This allows you to get as flexible as you would like. You can also create place holders for inline queries, which is a bit more involved and is really intended for the purposes of the return columns. But I would take the view approach as it is the most simple to implement.

StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » BrowseDialog - Adding a WHERE clause

BrowseDialog - Adding a WHERE clause

RE: BrowseDialog - Adding a WHERE clause