The MSCC4 standard specifies that a survey must contain either a VVR (Video volume reference new vol) or VID (Video file) Defect Code. The Video name then appears in the ‘Remarks’ column, see image below.
An SQL Can be used to populate the ‘InfoNet Video File’ field, see image below. The ‘InfoNet Video File’ field is what allows replay of the video to be made possible through the dialog box.
The SQL is as follows:
SET video_file_in = ‘UNC path’ + details.remarks WHERE details.code = ‘VVR’
To make the SQL interactive, we can use PROMPT.
PROMPT TITLE ‘SET CCTV Path’;
PROMPT LINE $Path ‘Enter UNC Path: ‘ STRING;
SET video_file_in = $Path + details.remarks WHERE details.code = ‘VVR’