SQL to SET the Video Path on a CCTV Survey

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.

VVR Defect Code

VVR Defect Code

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.

‘InfoNet Video File’ field

‘InfoNet Video File’ field

The SQL is as follows:

Set Path SQL

Set Path SQL

SET video_file_in = ‘UNC path’ + details.remarks WHERE details.code = ‘VVR’

To make the SQL interactive, we can use PROMPT.

Interactive SQL

Interactive SQL

PROMPT TITLE ‘SET CCTV Path’;
PROMPT LINE $Path ‘Enter UNC Path: ‘ STRING;
PROMPT DISPLAY;

SET video_file_in = $Path + details.remarks WHERE details.code = ‘VVR’

Share this post!

    About Idris Nujjoo

    Idris is the Product Sector Leader for InfoNet and InfoMaster and has been working for Innovyze (and its earlier incarnations) since 2001 and specifically working on InfoNet and Asset Management for the past decade.
    This entry was posted in InfoNet and tagged , , , , , . Bookmark the permalink.