Genesis Hybrid Smart Client Framework part III

��USE [BlueMarble.Genesis.Dev] /****** Object:  StoredProcedure [dbo].[Security_RibbonRole_Update]    Script Date: 05/20/2009 22:37:08 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

/*

----------------------------------------------------------------------------------------------------

-- Date Created: 20 May 2007



-- Created By: Eliyahu Business Systems (http://www.eliyahu.co.za)

-- Purpose: Updates a record in the Security_RibbonRole table

----------------------------------------------------------------------------------------------------

*/





CREATE PROCEDURE [dbo].[Security_RibbonRole_Update]

(



	@RibbonGuid uniqueidentifier   ,



	@OriginalRibbonGuid uniqueidentifier   ,



	@RoleGuid uniqueidentifier   ,



	@OriginalRoleGuid uniqueidentifier   

)

AS





				

				

				-- Modify the updatable columns

				UPDATE

					dbo.[Security_RibbonRole]

				SET

					[RibbonGuid] = @RibbonGuid

					,[RoleGuid] = @RoleGuid

				WHERE

[RibbonGuid] = @OriginalRibbonGuid 

AND [RoleGuid] = @OriginalRoleGuid

GO