×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I flubbed that one. Should be like this:
where (:ChristianName<>' ' and ChristianName=:ChristianName)
or (:Surname<>' ' and Surname=:Surname)
From: Darren Strong/DEKKO
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 11/12/2009 01:46 PM
Subject: RE: Load a subfile with clients selected by user
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
...
midrange.com
