USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALSUBDEPARTMENTCODEEXTENSION
The load procedure used by the edit dataform template "Educational Sub Department Code Extension Edit Data 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. |
| @TSLONG | bigint | INOUT | Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record. |
| @SHORTCODE | nvarchar(25) | INOUT | Short code |
| @CODETABLENAME | nvarchar(100) | INOUT | Code table name |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALSUBDEPARTMENTCODEEXTENSION
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@SHORTCODE nvarchar(25) = null output,
@CODETABLENAME nvarchar(100) = null output
)
as
set nocount on;
-- be sure to set these, in case the select returns no rows
set @DATALOADED = 0
set @TSLONG = 0
-- populate the output parameters, which correspond to fields on the form. Note that
-- we set @DATALOADED = 1 to indicate that the load was successful. Otherwise, the system
-- will display a "no data loaded" message. Also note that we fetch the TSLONG so that concurrency
-- can be considered.
if exists (select 1 from dbo.EDUCATIONALSUBDEPARTMENTCODEEXTENSION where ID = @ID)
begin
select
@DATALOADED = 1,
@TSLONG = TSLONG,
@SHORTCODE = SHORTCODE,
@CODETABLENAME = 'EDUCATIONALSUBDEPARTMENTCODE'
from dbo.EDUCATIONALSUBDEPARTMENTCODEEXTENSION
where ID = @ID
end
else
begin
if exists (select 1 from dbo.EDUCATIONALSUBDEPARTMENTCODE where ID = @ID)
begin
select
@DATALOADED = 1,
@TSLONG = 0,
@SHORTCODE = null,
@CODETABLENAME = 'EDUCATIONALSUBDEPARTMENTCODE'
from dbo.EDUCATIONALSUBDEPARTMENTCODE
where ID = @ID
end
end
return 0;