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.psHealthUniqueUsername ====== <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"."psHealthUniqueUsername"( in "StartName" char(100) ) returns char(100) begin declare "UName" char(100); declare "Inc" integer; set "UName" = "StartName"; set "Inc" = 0; while exists(select * from "psHealthPerson" where "username" = "UName") loop set "Inc" = "Inc"+1; set "UName" = "string"("StartName",' ',"Inc") end loop; return "UName" end </code> database/functions/pears_pshealthuniqueusername.txt Last modified: 2026/08/07 19:24by 127.0.0.1