EUR and search form

rbuser

Hi!
This question was probably explained but somehow I cannot find it.
I want to show search dialog in EUR for the SQL definitions which are not
made in RB SQL wizard but directly (manually edited SQL definition).
This is the case for Transform function (MS ACCESS) or any complex (Union or
query in query SQL definition).
Let us say that I will handle replacing the string (I have done one solid
SQL parser for that), but I need to get information how to setup Search
dialog in most common way. Please any example would say then 1000 words....
;9
I know Jim that you have think about that, so please forgive once more for
probably reposted topic.
Regards,
Funky Jr.

digitalmetaphors

Hi Funky II (younger). Please use a real name for our newsgroups. We'd like
to keep things around here as professional as possible.

Descend from the custom autosearch dialog class so that you aren't tied to
the descendent autosearch dialog class interface. Then you can do anything
you want in the form. Then in the Report.OnGetAutosearchValues, you can edit
the SQL in dataviews. Here are two examples that show these two things,
though you'll hae to code the relationship between these demos to do what
you want to do.

In D6 and RB 7.02 format:

http://www.digital-metaphors.com/tips/CustomAutosearchDialogRB7.zip

http://www.digital-metaphors.com/tips/EditSQLAndSearch.zip


Cheers,

Jim Bennett
Digital Metaphors