USP_DATAFORMINSTANCE_GETMETADATA

CREATE procedure dbo.USP_DATAFORMINSTANCE_GETMETADATA

@ID uniqueidentifier

as

    SET NOCOUNT ON;

    declare @SaveProc nvarchar(128);
    declare @LoadProc nvarchar(128);
    declare @FormUIXML xml;
    declare @TemplateSpecXML xml
    declare @Mode smallint;

    declare @ContextParam nvarchar(128);
    declare @ImplementationType tinyint;
    declare @AssemblyName nvarchar(128);
    declare @ClassName nvarchar(128);
    declare @HasChangeAgent bit;
    declare @HasTSLong bit;
    declare @HasAppUserForLoad bit;
    declare @HasAppUserForSave bit;
    declare @HasIDForLoad bit;
    declare @HasLoadProcedure bit;
    declare @Loaded bit;
    declare @TSLong bigint;

    set @Loaded = 0;

    select @Loaded = 1, @FormUIXML = DATAFORMINSTANCECATALOG.FORMUIXML, @Mode = DATAFORMTEMPLATECATALOG.MODE,
        @ImplementationType = DATAFORMTEMPLATECATALOG.IMPLEMENTATIONTYPE,
        @AssemblyName = DATAFORMTEMPLATECATALOG.ASSEMBLYNAME, @ClassName = DATAFORMTEMPLATECATALOG.CLASSNAME, 
        @LoadProc = coalesce(DATAFORMTEMPLATECATALOG.LOADPROCEDURE, ''), @SaveProc = coalesce(DATAFORMTEMPLATECATALOG.SAVEPROCEDURE, ''),
        @ContextParam = DATAFORMTEMPLATECATALOG.CONTEXTPARAMETERNAME,
        @TemplateSpecXML = DATAFORMTEMPLATECATALOG.TEMPLATESPECXML,
        @TSLong=DATAFORMINSTANCECATALOG.TSLONG,
        @HasAppUserForLoad=DATAFORMTEMPLATECATALOG.HASAPPUSERFORLOAD,
        @HasAppUserForSave=DATAFORMTEMPLATECATALOG.HASAPPUSERFORSAVE,
        @HasChangeAgent=DATAFORMTEMPLATECATALOG.HASCHANGEAGENT,
        @HasIDForLoad=DATAFORMTEMPLATECATALOG.HASIDFORLOAD,
        @HasTSLong=DATAFORMTEMPLATECATALOG.HASTSLONG

    from dbo.DATAFORMINSTANCECATALOG 
        inner join dbo.DATAFORMTEMPLATECATALOG on DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOG.ID
    where DATAFORMINSTANCECATALOG.ID = @ID;

    if @Loaded = 0
        return

    set @HasLoadProcedure = 0;

    if len(@LoadProc) > 0
        begin
            set @HasLoadProcedure = 1;

        end


    select    @FormUIXML 'FORMUIXML',
            @Mode 'MODE',
            @ImplementationType 'IMPLEMENTATIONTYPE',
            @AssemblyName 'ASSEMBLYNAME',
            @ClassName 'CLASSNAME',
            @ContextParam 'CONTEXTPARAMETERNAME',
            @HasChangeAgent 'HASCHANGEAGENT',
            @HasTSLong 'HASTSLONG',
            @HasAppUserForLoad 'HASAPPUSERFORLOAD',
            @HasAppUserForSave 'HASAPPUSERFORSAVE',
            @HasLoadProcedure 'HASLOADPROCEDURE',
            @HasIDForLoad 'HASIDFORLOAD',
            @TemplateSpecXML 'TEMPLATESPECXML',
            @TSLong 'TSLONG';