pears._NetPushNotificationsDeviceRemove

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

Original SQL

CREATE PROCEDURE "pears"."_NetPushNotificationsDeviceRemove"( IN "pWebUserID" CHAR(20),IN "pDeviceID" CHAR(20) ) 
RESULT( "pResult" CHAR(255) ) 
BEGIN
  DELETE FROM "PushNotificationDevice" WHERE "PushNotificationDeviceID" = "pDeviceID" AND "WebUserID" = "pWebUserID";
  SELECT '0:~Success'
END /* DOC
 
2019-10-23 GJ Creation.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."_NetPushNotificationsDeviceRemove" IS 
{CREATE PROCEDURE pears."_NetPushNotificationsDeviceRemove"( IN pWebUserID CHAR(20), IN pDeviceID CHAR(20))
RESULT(pResult CHAR(255) )
BEGIN
    DELETE FROM PushNotificationDevice WHERE PushNotificationDeviceID = pDeviceID AND WebUserID = pWebUserID;
 
    SELECT '0:~Success';
END
 
/* DOC
 
2019-10-23 GJ Creation.
 
*/
}