Foundset with where clause

Questions and answers regarding general SQL and backend databases

Foundset with where clause

Postby tjacobsz76 » Sun Feb 24, 2013 12:25 pm

Morning All,

For example, I've a table with members. It isn't allowed to delete records for my history so I add a column "Is_del".
0 = active and 1 = not active.

I only want to show active members.
I wonder if someone can tell me how I can add a where clause to a foundset.

Regards,

Tim
tjacobsz76
 
Posts: 1
Joined: Sun Feb 24, 2013 11:43 am

Re: Foundset with where clause

Postby Peter de Groot » Sun Feb 24, 2013 1:02 pm

Hello Tim,

Have a look at the databaseManager.addTableFilterParam() function.

Regards,

Peter
User avatar
Peter de Groot
 
Posts: 215
Joined: Thu Jan 10, 2008 8:38 pm
Location: Not sure...

Re: Foundset with where clause

Postby Hans Nieuwenhuis » Sun Feb 24, 2013 2:49 pm

Or addfoundsetfilter...
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 7 guests