<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":" Validating via an SQL Procedure Source Code create procedure mrcworklib.validdates (inout i_error char(99), inout i_strdate decimal(8,0), inout i_enddate decimal(8,0)) LANGUAGE SQL CASE when i_strdate = 0 and i_enddate = 0 then set i_error = 'You have not entered any dates.'; when i_strdate = 0 then set i_error = 'You must enter a starting date.'; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1580,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1609","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=1609"}],"version-history":[{"count":1,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1609\/revisions"}],"predecessor-version":[{"id":3428,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1609\/revisions\/3428"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1580"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}create procedure mrcworklib.validdates
\n(inout i_error char(99),
\n inout i_strdate decimal(8,0),
\n inout i_enddate decimal(8,0))
\nLANGUAGE SQL
\nCASE
\nwhen i_strdate = 0 and i_enddate = 0 then
\n set i_error = 'You have not entered any dates.';
\nwhen i_strdate = 0 then
\n set i_error = 'You must enter a starting date.';
\nwhen i_enddate = 0 then
\n set i_error = 'You must enter an ending date.';
\nwhen i_strdate > i_enddate then
\n set i_error = 'Start date is later than end date.';
\nelse
\n set i_error = ' ';
\nEND CASE<\/code><\/p>\n