USP_DATAFORMTEMPLATE_VIEW_CURRENCYEXCHANGERATEDOWNLOADPROCESSOUTPUT

The load procedure used by the view dataform template "Currency Exchange Rate Download Process Output 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.
@STATUS	xml	INOUT	Detail

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_CURRENCYEXCHANGERATEDOWNLOADPROCESSOUTPUT]
(
  @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @STATUS xml = null output
)
as
  set nocount on;

  declare @OUTPUT table ([FROMCURRENCY] nvarchar(110), [TOCURRENCY] nvarchar(110), [PARAMETERS] nvarchar(4000), [STATUS] nvarchar(4000));

  if exists (select top 1 1 from dbo.[BUSINESSPROCESSSTATUS] where [ID] = @ID)
    set @DATALOADED = 1;

  insert into @OUTPUT exec dbo.[USP_DATALIST_CURRENCYEXCHANGERATEDOWNLOADPROCESSOUTPUT] @ID;

  set @STATUS = (select * from @OUTPUT for xml raw('ITEM'), type, elements, root('STATUS'), binary base64);

  return 0;