www.icetips.com  Icetips Utilities Documentation 5/15/2016    

Procedure Extension Template: Icetips Fill Queue from VIEW

Previous  Top  Next  


This templates allows you to create a regular VIEW structure.  It can be useful when dealing with files, particularly SQL files where you only want certain columns from a table.  It lets you set up a queue with corresponding fields to the ones in the view.  This template is required by the "Fill Queue from SQL View" extension template, which loads the queue. 

     

Template_ITCreateFileView

 

View labelThe label that is used to create the VIEW.  It defaults to ITView and a number.  You can change it to anything as long as it doesn't create a duplicate label.

 

Field listThis is the list of fields that you select.  The list above would generate the VIEW structure below:
 
ITView2              VIEW(Products)
                      PROJECT(PRO:ProductNumber)
                      PROJECT(PRO:Description)
                      PROJECT(PRO:Price)
                    END

 

 

Template_ITCreateFileView_Properties

 

Field to add to viewSelect a field from the file schematic to add to the view as shown below.

 

Template_ITCreateFileView_SelectFile



Direct link to this page: http://www.icetips.com/manuals/utilities/icetipsfillqueuefromview.htm