spMFInsertProperty

Signature

EXEC dbo.spMFInsertProperty
    @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: Property data (XML).

@isFullUpdate

  • Type: BIT

  • Required: No (default = 0)

  • Description: When set to 1 updates all properties.

@Output

  • Type: NVARCHAR(50)

  • Required: No (OUTPUT)

  • Description: Return message.

@Debug

  • Type: SMALLINT

  • Required: No (default = 0)

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

Purpose

Insert Property details into MFProperty table. This procedure is used as part of the metadata structure update and is not used on its own.

Changelog

Date

Author

Description

2023-03-17

LC

Move check for duplicate properties to start of process

2019-08-30

JC

Added documentation

2018-11-04

LC

Enhancement to deal with changes in datatype

2017-12-28

DEV2

Change join condition at #1162

2017-11-30

LC

Remove duplicate _ID from State_ID

2017-11-23

LC

Localization of last modifed columns

2017-09-11

LC

Update constraints

2017-08-22

LC

Improve logging

2017-08-22

LC

Fix bug with contstraints

2015-07-14

DEV2

MFValuelist_ID column Added in MFProperty

2015-05-27

DEV2

New logic for inserting details from M-Files as per LeRoux

2015-05-15

DEV2

Checking for duplicate ColumnName and auto renaming if exists