Query by Example

Ebase Xi Sample Apps are downloadable from our website and demonstrate how to use particular features of the Xi environment. This forum is provided for discussion about the Sample Apps and as a place where ideas for further samples can be raised.

Moderators: Jon, Steve, Ian, Dave

jaffleck
Ebase User
Posts: 10
Joined: Sun Sep 15, 2013 7:44 pm
Location: Andover, MA

Query by Example

#1

Postby jaffleck » Wed Oct 09, 2013 12:06 am

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
0 x

User avatar
Wai
Moderator
Moderator
Posts: 165
Joined: Wed Sep 12, 2007 9:04 am
Location: Sandy, UK
Contact:

#2

Postby Wai » Wed Oct 09, 2013 8:07 am

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?
0 x

andyhinds
Forum Admin
Forum Admin
Posts: 55
Joined: Thu Oct 15, 2009 9:18 am

#3

Postby andyhinds » Wed Oct 09, 2013 10:25 am

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
0 x

jaffleck
Ebase User
Posts: 10
Joined: Sun Sep 15, 2013 7:44 pm
Location: Andover, MA

#4

Postby jaffleck » Sat Oct 12, 2013 2:58 pm

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

HBK

#5

Postby HBK » Tue Feb 03, 2015 7:53 am

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


Who is online

Users browsing this forum: No registered users and 4 guests