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.NetCandidatePersonWebHeadline ====== <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 procedure "pears"."NetCandidatePersonWebHeadline"( in "pWebUserID" char(20) ) result( "pHeadline" long varchar ) // IQXWeb begin select "IQXNetUserHeadline"("pWebUserID") end /* DOC 2020-06-07 GJ IW-1192 2020-07-24 ET IW-1192 Changed to pass pWebuserID instead of personID to IQXNetUserHeadline as it is expecting an iqxnetuserID not a personID */ /* TEST call NetTestSetup(''); select * from NetCandidatePersonWebHeadline('test.candidate'); expect row; */ go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidatePersonWebHeadline" IS {create PROCEDURE pears."NetCandidatePersonWebHeadline"(pWebUserID char(20)) RESULT(pHeadline long varchar ) // IQXWeb BEGIN select IQXNetUserHeadline(pWebUserID); END /* DOC 2020-06-07 GJ IW-1192 2020-07-24 ET IW-1192 Changed to pass pWebuserID instead of personID to IQXNetUserHeadline as it is expecting an iqxnetuserID not a personID */ /* TEST call NetTestSetup(''); select * from NetCandidatePersonWebHeadline('test.candidate'); expect row; */ } </code> database/procedures/pears_netcandidatepersonwebheadline.txt Last modified: 2026/08/07 19:24by 127.0.0.1