pears.NetCandidateTaxMethodDropdown

CREATE PROCEDURE "pears"."NetCandidateTaxMethodDropdown"( IN "pWebUserID" CHAR(20),IN "TaxMethod" CHAR(20) DEFAULT NULL ) 
RESULT( "Value" CHAR(20),"Descrip" CHAR(100),"selected" CHAR(1) ) 
BEGIN
  SELECT '1','PAYE',(IF "isnull"("TaxMethod",'') = 1 THEN '1' ELSE '0' endif) UNION
  SELECT '2','Limited company',(IF "isnull"("TaxMethod",'') = 2 THEN '1' ELSE '0' endif) UNION
  SELECT '3','self employed',(IF "isnull"("TaxMethod",'') = 3 THEN '1' ELSE '0' endif)
END /* DOC
 
2017-10-23 PC modify to return Selected parameter for dropdown on web page
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateTaxMethodDropdown" IS 
{CREATE PROCEDURE pears."NetCandidateTaxMethodDropdown"(IN pWebUserID CHAR(20), IN TaxMethod CHAR(20) DEFAULT NULL)
RESULT(VALUE CHAR(20),Descrip CHAR(100),selected CHAR(1) )
BEGIN
	SELECT '1','PAYE', (IF isnull(TaxMethod,'')=1 THEN '1' ELSE '0' endif)
  UNION
    SELECT '2','Limited company', (IF isnull(TaxMethod,'')=2 THEN '1' ELSE '0' endif)
  UNION 
    SELECT '3','self employed', (IF isnull(TaxMethod,'')=3 THEN '1' ELSE '0' endif)
END
 
/* DOC
 
2017-10-23 PC modify to return Selected parameter for dropdown on web page
 
*/
}