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.
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:
- Download the script.
- Extract the content of the downloaded zip file to the folder where the Project file you wish to check for deleted tags is stored.
- Right-click on the script file and, in the menu that ops up, click Run with PowerShell.
- The script will show you a File Open dialog that will allow you to select the project file you want to check.
- When it is done, it will tell you how many tags, if any, were deleted from the source text in the project, and it will show you the numbers of those tags.
If after step 3 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.
Comments