Follow

How to check if tags were deleted from the source in a project

This operation cannot be performed inside Déjà Vu. The SQL Statement option in the Segment Selector requires that you enter an SQL statement that returns a set of segments.
This will also not work with the Execute SQL command, because, though the SQL statement will be run, Déjà Vu does not have the ability to display the result of running this statement.

You can check if any tags were accidentally deleted from the source text of a project by opening the project file in Microsoft Accessnote and executing the following SQL query:

SELECT EmbeddedID
FROM Embedded
WHERE (SELECT COUNT(ID) FROM Pairs WHERE Source LIKE '*{' & EmbeddedID & '}*') = 0

You can also download a PowerShell script, that does the same thing and returns the result to the command line. To use the script:

  1. Download the script.
  2. Extract the content of the downloaded zip file to the folder where the Project file you wish to check for deleted tags is stored.
  3. Open a PowerShell window.
  4. Change the active directory to the folder where the project file is located.
  5. Type the following command (with the name of the file you want to process):

    .\Check-missingcodes.ps1 "Filename.dvprj" -ShowTags

  6. Press the Enter key.
  7. Wait for the script to finish checking the project file.
  8. When it is done, it will tell you how many tags were deleted from the source text in the project, and it will show you the numbers of those tags.

If after step 6 you see a message like this:

File .\Check-missingcodes.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help about_signing" for more details.

read this article for more information about how to proceed.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk