pears.SetQuestDate
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
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 }