Own dropdowns
Hi
My RB end user environment uses views, no tables.
The views contain both the id and the description for some fields.
Example : COUNTRY_ID and COUNTRY
The user may select "i want all customers from holland"
Now they have to fill in "holland"
I want the query to be :
select * from customers where country_id = 25
instead of
select * from customers where country = "Holland"
the one with the id is much faster.
So i want to give the users a dropdown with country selection and let fill
in the ID in the query.
Is this possible and if so is there an example?
Eric
My RB end user environment uses views, no tables.
The views contain both the id and the description for some fields.
Example : COUNTRY_ID and COUNTRY
The user may select "i want all customers from holland"
Now they have to fill in "holland"
I want the query to be :
select * from customers where country_id = 25
instead of
select * from customers where country = "Holland"
the one with the id is much faster.
So i want to give the users a dropdown with country selection and let fill
in the ID in the query.
Is this possible and if so is there an example?
Eric
This discussion has been closed.
Comments
- check out RBuilder\Demos\AutoSearch\Custom AutoSearch Dialog
- as shown in the example you can create a custom AutoSearchDialog class and
custom AutoSearchPanel classes. You AutoSearchDialog can contain logic to
determine which autoseachpanels are used for specific datafields.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com