pears.SetQuestDate

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

CREATE PROCEDURE "pears"."SetQuestDate"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "stagloc" CHAR(3),IN "stagid" CHAR(3),IN "sparentid" CHAR(20),IN "dvalue" DATE ) 
BEGIN
  CALL "setquestanswer"("stagloc","stagid",NULL,"sparentid","dateformat"("dvalue",'yyyy-mm-dd'))
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."SetQuestDate" IS 
{CREATE PROCEDURE SetQuestDate 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN stagloc CHAR(3),IN stagid CHAR(3),IN sparentid CHAR(20),IN dvalue DATE)
BEGIN
  CALL setquestanswer(stagloc,stagid,NULL,sparentid,dateformat(dvalue,'yyyy-mm-dd'))
END
}
  • database/procedures/pears_setquestdate.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1