Community Forum

I stumbled on to ebase and have played with it a bit. So far I like what I see. But I can't figure out how one would build a query-by-example form that would be used to select records from a database to be displayed in a subsequent form. Can anyone point me in the right direction?

Thanks.

Jim

Do you mean like an SQL builder where the user types in the SQL Query?

Or do you mean, having a number of pre-defined filter options that the user can select from which builds a query?

If you want an example of how to fetch data from a database based on a user entered value you can check out the "Tables" tutorial. Right at the end of the tutorial you will enhance a form that allows searching of database records for a user entered search term.:

http://dev-docs.verj.io/ufs/doc/tables_tutorial.htm

A completed version of this tutorial is available from the Sample Apps section of our website:

http://www.ebasetech.com/ufs/ufsmain?fo ... AMPLE_APPS

It is called "Tables" and is in the "Completed Tutorials" section.

Andy

Thanks so much. This is exactly what I needed to know!

having a number of pre-defined filter options that the user can select from which builds a query?