Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.IQXNetUserHeadline ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== Original SQL ===== <code sql> create function "pears"."IQXNetUserHeadline"( in "pWebUserID" char(20) ) returns long varchar begin declare "userClass" char(20); declare "personName" char(200); set "userClass" = (select first "iqxnetuserclassid" from "iqxnetuser" where "iqxnetuserid" = "pWebUserID"); set "personName" = (select "person"."forenames" from "iqxnetuser" key join "iqxnetuserlink" key join "person" where "iqxnetuser"."iqxnetuserid" = "pWebUserID"); return "string"('<h2> Hello ',"personName",', welcome to your portal.</h2>') end </code> database/functions/pears_iqxnetuserheadline.txt Last modified: 2026/08/07 19:24by 127.0.0.1