USP_RECORDOPERATION_ASKLADDERTOGGLEACTIVEPROMPT
Provides the prompt for the "Ask Ladder: Toggle Active Flag" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @NAME | nvarchar(100) | INOUT | |
| @TOGGLETEXT | nvarchar(8) | INOUT |
Definition
Copy
create procedure dbo.USP_RECORDOPERATION_ASKLADDERTOGGLEACTIVEPROMPT
(
@ID uniqueidentifier,
@NAME nvarchar(100) output,
@TOGGLETEXT nvarchar(8) output
)
as
set nocount on;
select
@NAME = [NAME],
@TOGGLETEXT = (case [ISACTIVE] when 0 then 'active' else 'inactive' end)
from
dbo.[MKTASKLADDER]
where
ID = @ID;
return 0;