USP_DATAFORMTEMPLATE_VIEW_BATCH2TEMPLATE
The load procedure used by the view dataform template "Batch Template Detail View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @DESCRIPTION | nvarchar(1000) | INOUT | Description |
| @BATCHTYPE | nvarchar(50) | INOUT | Batch type |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BATCH2TEMPLATE
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@DESCRIPTION nvarchar(1000) = null output,
@BATCHTYPE nvarchar(50) = null output
)
as
set nocount on;
select @DATALOADED = 1
,@DESCRIPTION = BT.DESCRIPTION
,@BATCHTYPE = BTC.NAME
from dbo.BATCHTEMPLATE as BT join BATCHTYPECATALOG as BTC on BT.BATCHTYPECATALOGID = BTC.ID
where BT.ID = @ID
return 0;