kmc
|
| Posted: 02/28/2002, 6:50 PM |
|
More for my wish list:
Listboxes:
1. I'd like to be able to have a "Where" option added to the Join tab area.
When making a listbox, the addition of a "WHERE" textbox
(above the SQL textbox) would be handy.
Many times the picklists are sufficient with just an
additional WHERE filter, but to add a simple WHERE
requires a full SQL entry.
It would be good to be able to just add in the
qualifying where to the already picked fields.
2. Many times the presentation of the listbox elements
needs ordering on other than the order within the lookup table.
Whenever this is required (almost always) an SQL statement
has to be entered, sort of defeating the point of the
present way to build listboxes.
An ORDER by option would be very useful.
Am I just too lazy??
Together, a WHERE and an ORDER BY in the listbox
join section would be an excellent enhancement.
I've put both of these forward as wishes,
hope they get yet approved for rating votes.
kmc
|
|
|
 |
Tom Smith
|
| Posted: 03/01/2002, 2:08 AM |
|
Hello,
looks like you really lazy. Imagine that you have WHERE and ORDER fields on listbox properties. You should enter Where and Order by clause manually (or select them) anyway. And in custom sql you should print only some additional words. Also if complex query need you cannot handle this task without custom sql.
|
|
|
|
|
