pears.NetOwnerSettingsSaveSwitches

CREATE PROCEDURE "pears"."NetOwnerSettingsSaveSwitches"( IN "pWebUserID" CHAR(20),IN "switchID" CHAR(50),IN "newValue" INTEGER ) 
RESULT( "pResult" CHAR(255) ) 
BEGIN
  IF "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
    SELECT '99:~Permission denied'
  ELSE
    UPDATE "IQXNetSwitch"
      SET "Value" = "newValue"
      WHERE "IQXNetSwitchID" = "switchID";
    SELECT '0:~Success'
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerSettingsSaveSwitches" IS 
{CREATE PROCEDURE pears."NetOwnerSettingsSaveSwitches"( IN "pWebUserID" CHAR(20), IN "switchID" CHAR(50), IN "newValue" INTEGER) 
RESULT(pResult CHAR(255) )
BEGIN
    IF "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
        SELECT '99:~Permission denied';
    ELSE
	    UPDATE IQXNetSwitch
        SET VALUE = newValue
        WHERE IQXNetSwitchID = switchID;
 
        SELECT '0:~Success';
    END IF;
END
}