spMFInsertClassProperty

Signature

EXEC dbo.spMFInsertClassProperty
    @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 property data (XML).

@isFullUpdate

  • Type: BIT

  • Required: No (default = 0)

  • Description: Flag from calling procedure; when set to 1 performs a full update.

@Output

  • Type: INT

  • Required: No (OUTPUT)

  • Description: Output status.

@Debug

  • Type: SMALLINT

  • Required: No (default = 0)

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

Purpose

To insert Class property details into MFClassProperty table. This is procedure is used internally only

Changelog

Date

Author

Description

2023-03-21

LC

Enforce adding name_or_title to class, even if not required

2022-12-01

LC

Improve debugging logging and handling of properties

2022-09-07

LC

Introduce columns RetainIfNull and IsAdditional

2020-12-23

LC

Add class as a property 100

2019-08-30

JC

Added documentation

2017-09-11

LC

Resolve issue with constraints

2015-04-07

DEV2

Resolved synchronization issue (Bug 55)