USP_DATAFORMTEMPLATE_VIEW_PRINTSETUP

The load procedure used by the view dataform template "Print Setup Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@STATUSWORKSTATIONS	nvarchar(3)	INOUT	workstations available
@STATUSPRINTERLISTS	nvarchar(3)	INOUT	printer lists available
@STATUSSALESDOCUMENTS	nvarchar(3)	INOUT	sales documents available
@STATUSPROGRAMS	nvarchar(3)	INOUT	programs available
@STATUSDELIVERYMETHODS	nvarchar(3)	INOUT	delivery methods available
@STATUSORGANIZATIONINFORMATION	nvarchar(3)	INOUT	Organization information

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PRINTSETUP
                (
                    @DATALOADED bit = 0 output,
                    @STATUSWORKSTATIONS nvarchar(3) = null output,
                    @STATUSPRINTERLISTS nvarchar(3) = null output,
                    @STATUSSALESDOCUMENTS nvarchar(3) = null output,
                    @STATUSPROGRAMS nvarchar(3) = null output,
                    @STATUSDELIVERYMETHODS nvarchar(3) = null output,
                    @STATUSORGANIZATIONINFORMATION nvarchar(3) = null output
                )
                as
                    set nocount on;

                    --Many variables are nvarchar instead of int; this is to facilitate string replacement in the UI

                    set @DATALOADED = 1
                    set @STATUSWORKSTATIONS = (select count(distinct WORKSTATION.ID) from dbo.WORKSTATION inner join dbo.WORKSTATIONPRINTER on WORKSTATION.ID = WORKSTATIONPRINTER.WORKSTATIONID);
                    set @STATUSPRINTERLISTS = (select count(ID) from dbo.PRINTERLIST);
                    set @STATUSSALESDOCUMENTS = (select count(distinct DOCUMENT.ID) 
                                                    from dbo.DOCUMENT 
                                                    left join dbo.DOCUMENTPRINTINGRULE 
                                                    on DOCUMENT.ID = DOCUMENTPRINTINGRULE.DOCUMENTID 
                                                    where DOCUMENT.ISACTIVE = 1 and 
                                                        DOCUMENT.PRINTERLISTID is not null and 
                                                        (DOCUMENT.TYPECODE in (5, 6) or (DOCUMENT.TYPECODE <= 4 and DOCUMENTPRINTINGRULE.ID is not null )));
                    set @STATUSPROGRAMS = 1;
                    set @STATUSDELIVERYMETHODS = 1;
                    set @STATUSORGANIZATIONINFORMATION = (select count(ID) from dbo.ORGANIZATIONINFORMATION);
                    return 0;