USP_USERDEFINEDELEMENT_MARKINACTIVE_PROMPTDATA
Provides the prompt for the "User-defined Element: Mark Inactive" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @ELEMENTNAME | nvarchar(60) | INOUT | |
| @SHORTID | nvarchar(10) | INOUT |
Definition
Copy
create procedure dbo.USP_USERDEFINEDELEMENT_MARKINACTIVE_PROMPTDATA
(
@ID uniqueidentifier,
@ELEMENTNAME nvarchar(60) = null output,
@SHORTID nvarchar(10) = null output
)
as begin
set nocount on;
select @ELEMENTNAME = ELEMENTNAME, @SHORTID = SHORTID from dbo.DATAELEMENT where ID=@ID
return 0;
end