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.TempShiftConfirmationAllowed ====== <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"."TempShiftConfirmationAllowed"( in "shiftid" char(20),in "TempOrClient" char(1),in "NewVal" smallint ) returns long varchar begin declare "rv" long varchar; if "NewVal" = 1 then set "rv" = ''; -- Return nothing if allowed -- TempOrClient T - Temp C - Client -- NewVal 1 - Confirm 0 - Unconfirm -- Return is prevalidation style not state change return "rv" end if end </code> database/functions/pears_tempshiftconfirmationallowed.txt Last modified: 2026/08/07 19:24by 127.0.0.1