USP_RECURRENCE_VIEW

The load procedure used by the view dataform template "Recurrence 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.
@RECURRENCETYPE	tinyint	INOUT	Recurrence Type
@INTERVAL	smallint	INOUT	Interval
@DAYOFWEEK	tinyint	INOUT	Day Of Week
@DAY	tinyint	INOUT	Day
@WEEK	tinyint	INOUT	Week
@MONTH	tinyint	INOUT	Month

Definition

Copy



                CREATE procedure dbo.USP_RECURRENCE_VIEW
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @RECURRENCETYPE tinyint = null output,
                    @INTERVAL smallint = null output,
                    @DAYOFWEEK tinyint = null output,
                    @DAY tinyint = null output,
                    @WEEK tinyint = null output,
                    @MONTH tinyint = null output
                )
                as
                    set nocount on;

                    -- be sure to set this, in case the select returns no rows

                    set @DATALOADED = 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.

                    select @DATALOADED = 1,
                           @RECURRENCETYPE = RECURRENCETYPE,
                           @INTERVAL = INTERVAL,
                           @DAYOFWEEK = DAYOFWEEK,
                           @DAY = DAY,
                           @WEEK = WEEK,
                           @MONTH = MONTH
                    from dbo.RECURRENCE
                    where ID = @ID

                    return 0;