Hi Team,
End Users generally aren't that familiar with writing Filter strings or
Query SQL.  As such they generally like a simple GUI/Dialog of some
sort to help them create the Filter/Query they need.

Question then - What EDBTable Filter and/or EDBQuery Query
components/dialogs are you using successfully with EDB for your
Apps/Users?

I have used InfoPower's TwwFilterDialog for a long time and in generl
it does OK but it isn't without its foibles.

On the look out for alternative(s).

Regards & TIA,
Ian

Ian Branch wrote:

> Hi Team,
> End Users generally aren't that familiar with writing Filter strings
> or Query SQL.  As such they generally like a simple GUI/Dialog of some
> sort to help them create the Filter/Query they need.
>
> Question then - What EDBTable Filter and/or EDBQuery Query
> components/dialogs are you using successfully with EDB for your
> Apps/Users?
>
> I have used InfoPower's TwwFilterDialog for a long time and in generl
> it does OK but it isn't without its foibles.
>
> On the look out for alternative(s).
>
> Regards & TIA,
> Ian

You can try the SQL-Framework from Alexander Sviridenkov
(delphihtmlcomponents.com). We have payed him in the beginning of this
year to include ElevateDB Syntax into his component so it is working
fine. Look at this video: https://www.youtube.com/watch?v=v1B2zkm9w5Q

--
--
Yusuf Zorlu | MicrotronX

Ian


Naturally I wrote my own

Roy Lambert

Hi Yusef,
   Thanks for your suggestion.
   For me that would work fine.  For my Users, not so much.
Regards,
Ian

Of course.

Ian Branch wrote:

> End Users generally aren't that familiar with writing Filter strings or
> Query SQL.  

Very much so. When I wrote my web shop, the admin needs to search. But just as when you Google, you don't have to define some fancy query, just find me the thing I'm looking for! And that's what I did - you type a simple string, it looks everywhere that is sensible. In an accounting program, searching for "471" should get you invoice 471, the bill for $471, and the person who lives at 471 High Street. Have a "search in" option if you want, but default to all the places.

Make the computer do the work, not your users. (In my opinion... 8-)

--

Matthew Jones

Matthew


Not a bad approach most of the time but just like Google you can get a lot of undesired hits. If I was looking for an invoice value I'd be peeved by records coming up because of the address.

Roy Lambert

Roy Lambert wrote:

> Matthew
>
>
> Not a bad approach most of the time but just like Google you can get a lot of undesired hits. If I was looking for an invoice value I'd be peeved by records coming up because of the address.
>
> Roy Lambert

Hence having a set of checkboxes to remove things that aren't relevant. People are usually pretty good at spotting the thing they want out of a list though. It works for me! 8-)

--

Matthew Jones