pears.NetResetPassword [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NetResetPassword ======
<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 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
*/
}
</code>