USP_DATAFORMTEMPLATE_ADD_DEFAULTCOMMENT_PRELOAD

The load procedure used by the edit dataform template "Default Comment Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SEQUENCE	int	INOUT	Comment number

Definition

Copy



          create procedure dbo.USP_DATAFORMTEMPLATE_ADD_DEFAULTCOMMENT_PRELOAD
(
    @SEQUENCE int = null output
)
as
    set nocount on;

     declare @NEWSEQUENCE int
     select @NEWSEQUENCE = MAX(SEQUENCE) FROM dbo.DEFAULTCOMMENT 
     set @NEWSEQUENCE = coalesce(@NEWSEQUENCE,0) + 1
     set @SEQUENCE = @NEWSEQUENCE

    return 0;