USP_LANGUAGE_RESOURCES_SAVE

The save procedure used by the add dataform template "LanguageResourcesOverrides Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CONTENTID	int	IN
@TEXT	nvarchar(1024)	IN
@CULTURECODE	nvarchar(10)	IN
@RESOURCETYPE	nvarchar(1024)	IN
@RESOURCEKEY	nvarchar(255)	IN

Definition

Copy



                    CREATE procedure dbo.USP_LANGUAGE_RESOURCES_SAVE
                    (
                        @ID uniqueidentifier = null output,
                        @CONTENTID int,
                        @TEXT nvarchar(1024),
                        @CULTURECODE nvarchar(10),
                        @RESOURCETYPE nvarchar(1024),
                        @RESOURCEKEY nvarchar(255)
                    )
                    as
                    begin
                        -- currently only inserts one at a time, need to get more efficient method in the future

                        declare @RESOURCESID as uniqueidentifier
                        select @RESOURCESID = ID from dbo.LANGUAGE_RESOURCES where
                        CULTURECODE = @CULTURECODE and RESOURCETYPE = @RESOURCETYPE and RESOURCEKEY = @RESOURCEKEY

                        delete from LANGUAGE_RESOURCES_OVERRIDES where LANGUAGERESOURCEGUID = @RESOURCESID

                        insert into LANGUAGE_RESOURCES_OVERRIDES (LANGUAGERESOURCEGUID, CONTENTID, TEXT)
                        values (@RESOURCESID, @CONTENTID, @TEXT)
                    end