On Thu, Oct 12, 2017 at 10:00 AM, Bob Sneidar via use-livecode < use-livecode@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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
