When I use this to create a view:
CREATE OR REPLACE VIEW GISPATRONS
(PROPID, LASTNAME, FIRSTNAME, MIDDLENAME, STATUS)
AS
SELECT COUNTYID.PROPID, PATRONS.LASTNAME, PATRONS.FIRSTNAME,
PATRONS.MIDDLENAME,
CASE
WHEN VERIFYEXPIRATION >= DATE THEN '1'
WHEN VERIFYEXPIRATION < DATE OR VERIFYEXPIRATION IS NULL THEN '0'
END
FROM PATRONRELATIONS PATRONRELATIONS
INNER JOIN PATRONS PATRONS ON
PATRONRELATIONS.PRIMARYPATRONID=PATRONS.PATRONID AND
PATRONRELATIONS.SECONDARYPATRONID=PATRONS.PATRONID
INNER JOIN PATRONADDRESSES PATRONADDRESSES ON
PATRONRELATIONS.ADDRESSID=PATRONADDRESSES.ADDRESSID
INNER JOIN COUNTYID COUNTYID ON
PATRONADDRESSES.ADDRESS1=COUNTYID.SITEADDRESS
WHERE COUNTYID.PROPID is not NULL
the STATUS column returns either a '1' as expected or hFF instead of a
'0'. When run as a query, everything is OK.
Tried on 7.5.0.5 and 7.6.0.10 with same results.
Don Hayes
Database Administrator
Tualatin Hills Parks & Recreation District
Phone: (503) 614-1219
FAX: (503) 629-5398
