pears.NetResetPassword

CREATE PROCEDURE "pears"."NetResetPassword"( IN "pWebUserID" CHAR(20),IN @token CHAR(100) ) 
RESULT( "Token" CHAR(100),"WhenCreated" TIMESTAMP ) 
// IQXWeb
BEGIN
  SELECT "BASE64_DECODE"(@token),
    "WhenCreated"
    FROM "IQXNetPasswordChangeRequest"
    WHERE "Token" = @Token
    AND "Sent" = 1
END /* TEST
 
*/
/* DOC
15-01-2019 GJ Created
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetResetPassword" IS 
{CREATE PROCEDURE pears."NetResetPassword"(IN pWebUserID CHAR(20),IN @token CHAR(100))
RESULT(Token CHAR(100), WhenCreated TIMESTAMP)
// IQXWeb
BEGIN
    SELECT 
        BASE64_DECODE(@token), 
        WhenCreated 
    FROM 
        IQXNetPasswordChangeRequest 
    WHERE
        Token = @Token
        AND
        Sent = 1
END
 
/* TEST
 
*/
 
/* DOC
    15-01-2019 GJ Created
*/
}