Page 1 of 1
Query by Example
Posted: Wed Oct 09, 2013 12:06 am
by jaffleck
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
Posted: Wed Oct 09, 2013 8:07 am
by Wai
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?
Posted: Wed Oct 09, 2013 10:25 am
by andyhinds
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
Posted: Sat Oct 12, 2013 2:58 pm
by jaffleck
Thanks so much. This is exactly what I needed to know!
Posted: Tue Feb 03, 2015 7:53 am
by HBK
having a number of pre-defined filter options that the user can select from which builds a query?