labtech Database

Parameters

Name	Type	Mode
argRoleName	varchar(255)	IN
argRoleType	varchar(255)	IN
argRoleSubType	varchar(255)	IN
argDetectionString	varchar(4096)	IN
argComparisonOperator	char(16)	IN
argComparisonResult	varchar(1024)	IN
argSerialKeyString	varchar(4096)	IN
argProductKeyString	varchar(4096)	IN
argRoleDetectionGuid	char(50)	IN
argIsRemote	tinyint	IN
argSearchId	int	IN
argIsSupport	tinyint	IN
argParentRoleDefinitionGuid	char(50)	IN

Definition

BEGIN
	DECLARE _existingRoleId INT(11);
	
	SET _existingRoleId = (SELECT RoleDefinitionId FROM RoleDefinitions WHERE RoleDetectionGuid = argRoleDetectionGuid);

if ISNULL(_existingRoleId) THEN
		INSERT INTO `RoleDefinitions` (`RoleName`, `RoleType`, `RoleSubType`, `DetectionString`, `ComparisonOperator`, `ComparisonResult`, `SerialKeyString`, `ProductKeyString`, `RoleDetectionGuid`, `IsRemote`, `SearchId`, `IsSupport`, `ParentRoleDefinitionGuid`) 
				VALUES(argRoleName, argRoleType,argRoleSubType,argDetectionString,argComparisonOperator,argComparisonResult,argSerialKeyString,argProductKeyString,argRoleDetectionGuid,argIsRemote,argSearchId,argIsSupport,argParentRoleDefinitionGuid);
	ELSE
		Update RoleDefinitions 
		SET
			RoleName = argRoleName, RoleType = argRoleType, RoleSubType = argRoleSubType, DetectionString = argDetectionString,
			ComparisonOperator = argComparisonOperator, ComparisonResult = argComparisonResult, SerialKeyString = argSerialKeyString,
			ProductKeyString = argProductKeyString, RoleDetectionGuid = argRoleDetectionGuid, IsRemote = argIsRemote, SearchId = argSearchId, 
			IsSupport = argIsSupport, ParentRoleDefinitionGuid = argParentRoleDefinitionGuid
		WHERE
			RoleDefinitionId = _existingRoleId;
	END IF;

END

sp_AddUpdateRoleDefinition

Parameters

Definition