pears.EmailLetterAsAttachmentFileName

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."EmailLetterAsAttachmentFileName" IS 
{CREATE FUNCTION EmailLetterAsAttachmentFileName( IN "tempid" CHAR(20) ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  DECLARE "coname" CHAR(30);
  SELECT "dbname" INTO "coname" FROM "params";
  // SELECT description INTO rv FROM templatestore WHERE templateid = tempid; 
  // IF rv IS NULL THEN 
  SET "rv" = String(coname,' Letter'); //   NB do NOT ADD IN file extension
  // END IF;
  RETURN("rv")
END
}