RE: Load a subfile with clients selected by user

Good point, I did not think this through very well. I suppose you get the
point, even if I'm having trouble getting the and/or logic correct.

This should filter for values that are known, and leave open, values that
are left or set blank:
where (:ChristianName=' ' or ChristianName=:ChristianName)
and (:Surname=' ' or Surname=:Surname)





From: rob@xxxxxxxxx
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 11/12/2009 03:07 PM
Subject: RE: Load a subfile with clients selected by user
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



Darren,

If :ChristianName is blank then will it select any records?


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: darren@xxxxxxxxx
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 11/12/2009 01:51 PM
Subject: RE: Load a subfile with clients selected by user
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



I've also used something like this, as an alternative to the 'between'
clause. Don't forget that you can compare values of host variables to
constants, to make application decisions in query.

where :ChristianName<>' ' and ChristianName=:ChristianName
and :Surname<>' ' and Surname=:Surname

Rob wrote snippet:

exec sql
Declare C1 cursor for
select ...
from ...
where ChristianName between :ChristianNameL
and :Christiannameh
and Surname between :SurnameL
and :SurnameH
...




--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.