pears._NetPushNotificationsDevices

CREATE PROCEDURE "pears"."_NetPushNotificationsDevices"( IN "pWebUserID" CHAR(20) ) 
RESULT( "PushNotificationDeviceID" CHAR(20),"DeviceName" CHAR(100),"DeviceType" SMALLINT,"WhenCreated" "datetime" ) 
BEGIN
  SELECT "PushNotificationDeviceID",
    "DeviceName",
    "DeviceType",
    "WhenCreated"
    FROM "PushNotificationDevice"
    WHERE "WebUserID" = "pWebUserID"
END /* DOC
 
2019-10-04 GJ Creation.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."_NetPushNotificationsDevices" IS 
{CREATE PROCEDURE pears."_NetPushNotificationsDevices"( IN pWebUserID CHAR(20) )
RESULT("PushNotificationDeviceID" CHAR(20),	"DeviceName" CHAR(100),	"DeviceType" SMALLINT, "WhenCreated" datetime )
BEGIN
    SELECT
        PushNotificationDeviceID,
        DeviceName,
        DeviceType,
        WhenCreated
    FROM
        PushNotificationDevice
    WHERE
        WebUserID = pWebUserID;
END
 
/* DOC
 
2019-10-04 GJ Creation.
 
*/
}