pears._NetPushNotificationsDeviceEdit

CREATE PROCEDURE "pears"."_NetPushNotificationsDeviceEdit"( IN "pWebUserID" CHAR(20),IN "pDeviceID" CHAR(20),IN "pDeviceName" CHAR(100) ) 
RESULT( "pResult" CHAR(255) ) 
BEGIN
  UPDATE "PushNotificationDevice"
    SET "Devicename" = "pDeviceName"
    WHERE "PushNotificationDeviceID" = "pDeviceID"
    AND "WebUserID" = "pWebUserID";
  SELECT '0:~Success'
END /* DOC
 
2019-11-06 GJ Creation.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."_NetPushNotificationsDeviceEdit" IS 
{CREATE PROCEDURE pears."_NetPushNotificationsDeviceEdit"( IN pWebUserID CHAR(20), IN pDeviceID CHAR(20), IN pDeviceName CHAR(100) )
RESULT(pResult CHAR(255) )
BEGIN
    UPDATE PushNotificationDevice 
        SET Devicename = pDeviceName 
        WHERE PushNotificationDeviceID = pDeviceID
         AND
         WebUserID = pWebUserID;
 
    SELECT '0:~Success';
END
 
/* DOC
 
2019-11-06 GJ Creation.
 
*/
}