USP_DATAFORMTEMPLATE_VIEW_AMPROIMPORT_ITEM

The load procedure used by the view dataform template "AuctionMaestro Pro Import Item 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.
@MAPPINGID	int	INOUT	MAPPINGID
@NAME	nvarchar(100)	INOUT	NAME
@CATEGORY	nvarchar(100)	INOUT	CATEGORY
@SUBCATEGORY	nvarchar(100)	INOUT	SUBCATEGORY
@DESCRIPTION	nvarchar(255)	INOUT	DESCRIPTION
@EXPIRATIONDATE	datetime	INOUT	EXPIRATIONDATE
@DONATIONDATE	datetime	INOUT	DONATIONDATE
@VALUE	money	INOUT	VALUE
@MINIMUMBID	money	INOUT	MINIMUMBID
@DONORID	uniqueidentifier	INOUT	DONORID
@WRITTENOFF	bit	INOUT	WRITTENOFF
@PURCHASED	bit	INOUT	PURCHASED
@SITEID	uniqueidentifier	INOUT	SITEID
@EVENTAUCTIONID	uniqueidentifier	INOUT	EVENTAUCTIONID
@ISPACKAGE	bit	INOUT	ISPACKAGE
@ISPOSTED	bit	INOUT	ISPOSTED

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_AMPROIMPORT_ITEM
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @MAPPINGID int = null output,
                    @NAME nvarchar(100) = null output,
                    @CATEGORY nvarchar(100) = null output,
                    @SUBCATEGORY nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @EXPIRATIONDATE datetime = null output,
                    @DONATIONDATE datetime = null output,
                    @VALUE money = null output,
                    @MINIMUMBID money = null output,
                    @DONORID uniqueidentifier = null output,
                    @WRITTENOFF bit = null output,
                    @PURCHASED bit = null output,
                    @SITEID uniqueidentifier = null output,
                    @EVENTAUCTIONID uniqueidentifier = null output,
                    @ISPACKAGE bit = null output,
                    @ISPOSTED bit = null output
                )
                as
                set nocount on;

                    select 
                        @DATALOADED = 1,
                        @MAPPINGID = MAPPINGID,
                        @NAME = NAME,
                        @CATEGORY = CATEGORY,
                        @SUBCATEGORY = SUBCATEGORY,
                        @DESCRIPTION = DESCRIPTION,
                        @EXPIRATIONDATE = EXPIRATIONDATE,
                        @DONATIONDATE = DATE,
                        @VALUE = VALUE,
                        @MINIMUMBID = MINIMUMBID,
                        @DONORID = DONORID,
                        @WRITTENOFF = WRITTENOFF,
                        @PURCHASED = PURCHASED,
                        @SITEID = SITEID,
                        @EVENTAUCTIONID = EVENTAUCTIONID,
                        @ISPACKAGE = ISPACKAGE,
                        @ISPOSTED = POSTED
                    from dbo.UFN_AMPROIMPORT_ITEMDATA(@ID);