IQX Quick Menu

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

CREATE FUNCTION "pears"."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

pears.EmailLetterAsAttachmentFileName

Original SQL

iqx