pears.WPKViewItemView

CREATE VIEW "pears"."WPKViewItemView"( "WPKViewItemID",
  "WPKViewID","WPKFormID","Name","ItemType","Notes","SortOrder","CanView","CanEdit","Required","DefaultValue","Mask",
  "ComplexDataUpdateCommand","PickList","CheckValues","Sortable","BackColour","FontColour","Indent","DisplaySize","Descriptor",
  "DataType","DataLength","DisplayFormat","SortExpression","IDforVideoRecordType","Image","Expanded","CaptionBackColour",
  "CaptionFontColour","ComboScript","ButtonGroup","DivisionID","Position","Custom" ) AS
  SELECT "WPKViewItem"."WPKViewItemID","WPKViewItem"."WPKViewID","WPKViewItem"."WPKFormID","WPKViewItem"."Name","WPKViewItem"."ItemType","WPKViewItem"."Notes","WPKViewItem"."SortOrder","WPKViewItem"."CanView","WPKViewItem"."CanEdit","WPKViewItem"."Required","WPKViewItem"."DefaultValue","WPKViewItem"."Mask",
    "WPKViewItem"."ComplexDataUpdateCommand","WPKViewItem"."PickList","WPKViewItem"."CheckValues","WPKViewItem"."Sortable","WPKViewItem"."BackColour","WPKViewItem"."FontColour","WPKViewItem"."Indent","WPKViewItem"."DisplaySize","WPKViewItem"."Descriptor",
    "WPKViewItem"."DataType","WPKViewItem"."DataLength","WPKViewItem"."DisplayFormat","WPKViewItem"."SortExpression","WPKViewItem"."IDforVideoRecordType","WPKViewItem"."Image","WPKViewItem"."Expanded","WPKViewItem"."CaptionBackColour",
    "WPKViewItem"."CaptionFontColour","WPKViewItem"."ComboScript","WPKViewItem"."ButtonGroup",NULL AS "DivisionID",-1 AS "Position",0 AS "Custom" FROM "pears"."WPKViewItem" UNION ALL
  SELECT "WPKCustomGridColumn"."WPKCustomGridColumnID","WPKCustomGridColumn"."WPKViewID","WPKCustomGridColumn"."WPKFormID","WPKCustomGridColumn"."Name","WPKCustomGridColumn"."ItemType","WPKCustomGridColumn"."Notes",0 AS "SortOrder",NULL AS "CanView",NULL AS "CanEdit",NULL AS "Required",NULL AS "DefaultValue",NULL AS "Mask",
    NULL AS "ComplexDataUpdateCommand","WPKCustomGridColumn"."PickList","WPKCustomGridColumn"."CheckValues","WPKCustomGridColumn"."Sortable",NULL AS "BackColour",NULL AS "FontColour",0 AS "Indent","WPKCustomGridColumn"."DisplaySize","WPKCustomGridColumn"."Descriptor",
    "WPKCustomGridColumn"."DataType","WPKCustomGridColumn"."DataLength","WPKCustomGridColumn"."DisplayFormat","WPKCustomGridColumn"."SortExpression",NULL AS "IDforVideoRecordType",NULL AS "Image",NULL AS "Expanded",NULL AS "CaptionBackColour",
    NULL AS "CaptionFontColour",NULL AS "ComboScript",0 AS "ButtonGroup","WPKCustomGridColumn"."DivisionID","isnull"("WPKCustomGridColumn"."Position",-1),1 AS "Custom" FROM "pears"."WPKCustomGridColumn"
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."WPKViewItemView" IS 
{CREATE VIEW WPKViewItemView 
(WPKViewItemID,WPKViewID,WPKFormID,Name,ItemType,Notes,SortOrder,CanView,CanEdit,Required,DefaultValue,Mask,
ComplexDataUpdateCommand,PickList,CheckValues,Sortable,BackColour,FontColour,Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,IDforVideoRecordType,Image,Expanded,CaptionBackColour,
CaptionFontColour,ComboScript,ButtonGroup,DivisionID,POSITION,Custom) 
AS SELECT WPKViewItemID,WPKViewID,WPKFormID,Name,ItemType,Notes,SortOrder,CanView,CanEdit,Required,DefaultValue,Mask,
ComplexDataUpdateCommand,PickList,CheckValues,Sortable,BackColour,FontColour,Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,IDforVideoRecordType,Image,Expanded,CaptionBackColour,
CaptionFontColour,ComboScript,ButtonGroup,NULL AS DivisionID,-1 AS POSITION,0 AS Custom FROM WPKViewItem 
 UNION ALL 
SELECT WPKCustomGridColumnID,WPKViewID,WPKFormID,Name,ItemType,Notes,0 AS SortOrder,NULL AS CanView,NULL AS CanEdit,NULL AS Required,NULL AS DefaultValue,NULL AS Mask,
NULL AS ComplexDataUpdateCommand,PickList,CheckValues,Sortable,NULL AS BackColour,NULL AS FontColour,0 AS Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,NULL AS IDforVideoRecordType,NULL AS Image,NULL AS Expanded,NULL AS CaptionBackColour,
NULL AS CaptionFontColour,NULL AS ComboScript,0 AS ButtonGroup, DivisionID, isnull(POSITION,-1),1 AS Custom FROM WPKCustomGridColumn
}