Skip to main content
Skip table of contents

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 

  1. Start SqlHelper.exe


  2. Select "Access (ODBC)" as Provider
  3. Enter the path to your Access database (mdb file) in Server/DataSource.
  4. Click "Connect"


  5. Navigate to the SQL tab
  6. Select a DigaSystem table, e.g. "Local"
  7. Select "Delete obsolete music markers" from Templates


  8. Click "Execute Query"
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.