pears.PDFDisplayContent

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

CREATE FUNCTION "pears"."PDFDisplayContent"( IN "formid" CHAR(50),IN "viewid" CHAR(50),IN "recordid" CHAR(20) ) 
RETURNS long VARCHAR
-- formid - recordid, PERSON - personid, COMPANY, companyID, VACANCY - vacancyid, PLACEMENT, placementid
-- rv is either
-- PATH UNCpath (space separator optional)
-- BLOB blobid|blobclass
-- REPORT filename|title|params (| separated)
BEGIN
  DECLARE "rv" long VARCHAR;
  SET "rv" = '';
  RETURN("rv")
END

pears.PDFDisplayContent

Original SQL

iqx