Query Input Form

Trevor DeVore lists at mangomultimedia.com
Fri Oct 13 09:58:24 EDT 2017


On Thu, Oct 12, 2017 at 10:00 AM, Bob Sneidar via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Has anyone put together a query input form, that can take simple input
> from a user, like:
> customers.customername is/is not/is greater than/is less than/is like
> <value> AND/OR
> <next condition> AND/OR
> <next condition> ...
>
> and then build an sql query for it?
>

Bob,

If you are using SQL Yoga with this project then Scopes will make the SQL
Query part very straightforward. You would create a scope for each
condition and then add the scope to the SQL Query object based on the user
input in the form. SQL Yoga will generate the WHERE clause using any scopes
that have been added to the SQL Query object.

http://revolution.screenstepslive.com/s/revolution/m/sqlyoga_sampleapp/l/6637-defining-scopes-to-make-aggregating-search-filters-easier

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com



More information about the use-livecode mailing list