1. Home
  2. Labeling Software
  3. LABEL ARCHIVE
  4. LABEL ARCHIVE Instructions
  5. Change Document Version Number from 1 to 0 – LABEL ARCHIVE Instructions

Change Document Version Number from 1 to 0 – LABEL ARCHIVE Instructions

Target Audience: Advanced User

Article #: 8873

Summary

This Instruction Article shows how to change the document version number from 1 to 0 in LABEL ARCHIVE 2018 (or later) or TEKLYNX CENTRAL 5.0 R2 (or later).

Preparation

This article assumes that you have:

  • An understanding of LABEL ARCHIVE at operation level
  • A very good working knowledge of SQL Management Studio
  • A good working knowledge of SQL Management Studio to modify existing data

Note:

    • This article is to be used only if you want the document number to start from version 0 instead of version 1 in LABEL ARCHIVE or TEKLYNX CENTRAL.
    • This instruction only applies to TEKLYNX CENTRAL 5.0 R2 with PostReleaseFixes_v2 installed.
    • It should only be used when the document is freshly Checked-In to LABEL ARCHIVE as version 1
    • We believe that the procedure described in this article is accurate. However, we make no direct or imply warranty to its accuracy and completeness.  Use these instructions at your own risk.

 

Instructions

  1. Identify the document you wish to change the version from 1 to 0. In this article we will use Test10.lab. Remember the file name.
  2. Open SQL Management Studio. Open LABELARCHIVE database and expand Tables.
  3. In the dbo.tblDocuments table, right click and select Edit top 200 rows.
  4. Modify the SQL statement for the edit by clicking on the SQL button on the toolbar.
  5. Add WHERE DOCNAME = ‘Test10.lab’ to the end of the select statement and click on the ! button on the toolbar to refresh the screen
  6. Look for DOCID for Test10.lab. In this example, it is 1129.
  7. In the dbo.tblHistory table, right click and select Edit top 200 rows.
  8. Modify the SQL statement for the edit by clicking on the SQL button on the toolbar.
  9. Add WHERE DOCID = 1129 to the end of the select statement and click on the ! button on the toolbar to refresh the screen
  10. Repeat steps 7-9 for dbo.tblMetaDataDocuments
  11. Repeat steps 7-9 for dbo.tblMetaDataTexts
  12. At this point, you should have 4 tabs available in the SQL Management Studio screen.
  13. Change DOCVERSION in each of the tabs from 1 to 0. Be sure to press ENTER after each change.
  14. The final results should look similar to this:
Updated on April 15, 2019

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support