USP_DATAFORMTEMPLATE_ADD_SITETOHIERARCHY_PRELOAD
The load procedure used by the edit dataform template "Site Hierarchy Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PARENTSITEID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @PARENTSITENAME | nvarchar(1024) | INOUT | PARENTSITENAME |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SITETOHIERARCHY_PRELOAD
(
@PARENTSITEID uniqueidentifier,
@PARENTSITENAME nvarchar(1024) = null output
)
as
set nocount on;
select
@PARENTSITENAME = SITE.NAME
from
dbo.SITE
where
SITE.ID = @PARENTSITEID;
return 0;