spMFInsertClass

Signature

EXEC dbo.spMFInsertClass
    @Doc = N'<xml>',
    @isFullUpdate = 0,
    @Output = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Doc
  • Type: NVARCHAR(MAX)

  • Required: Yes

  • Description: Class data (XML).

@isFullUpdate
  • Type: BIT

  • Required: No (default = 0)

  • Description: When set to 1 performs a full update.

@Output
  • Type: INT

  • Required: No (OUTPUT)

  • Description: Status or count output value.

@Debug
  • Type: SMALLINT

  • Required: No (default = 0)

  • Description: Debug level. - 1 = Standard Debug Mode - 101 = Advanced Debug Mode

Purpose

The purpose of this procedure is to insert Class details into MFClass table.

Changelog

Date

Author

Description

2025-04-0

JPE

Update MFObjectType_ID and Deleted in MFClass update (merge)

2022-09-07

LC

Update changes to classProperty table

2022-01-04

LC

Add assembly logging to app detail logging

2019-08-30

JC

Added documentation

2018-11-10

LC

Add includedinApp update for User Messager table

2018-03-26

DEV2

Workflow required check

2016-03-19

LC

No error for duplicate Report Class

2015-07-20

DEV2

TableName Duplicate Issue Resolved

2015-07-14

DEV2

MFValuelist_ID column removed from MFClass

2015-05-27

DEV2

INSERT/UPDATE logic changed