Deleting obsolete music markers from subclip list

Older versions of Database Manager (DBM) stored music marker values in two metadata locations:

as entry properties and
as a special type of subclip (with subclip types 'MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')

These special subclips are obsolete and should be deleted.

Microsoft SQL database server

Execute following script in e.g. MS SQL Management Studio.

Replace

DigaSystem with the name of your database
Table with the name of your table

CODE

DELETE
FROM [DigaSystem].[david].[Table_C]
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')

MySQL database server

Execute following script in e.g. MySQL Workbench.

Replace

DigaSystem with the name of your database
Table with the name of your table

CODE

DELETE
FROM DigaSystem.Table_C
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')

Oracle database server

Execute following script in e.g. SQL Developer.

Replace

DigaSystem with the name of your database
Table with the name of your table

CODE

USE DATABASE DigSystem;
DELETE
FROM Table_C
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')

MS Access database

Execute a SQL delete command in SqlHelper.exe from DAVID Systems.

You can get this software from DAVID Support Team, just contact support@davidsystems.com

Start SqlHelper.exe
Select "Access (ODBC)" as Provider
Enter the path to your Access database (mdb file) in Server/DataSource.
Click "Connect"
Navigate to the SQL tab
Select a DigaSystem table, e.g. "Local"
Select "Delete obsolete music markers" from Templates
Click "Execute Query"