pears.WPKViewItem

Woodpecker View Item definitions.

• WPKViewItemID, WPKViewID, WPKFormID

• No incoming foreign keys found.

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKViewItem"
-- Table comment: Woodpecker View Item definitions.
-- Statement count: 32
 
CREATE TABLE "pears"."WPKViewItem" (
    "WPKViewItemID"                  CHAR(50) NOT NULL
   ,"WPKViewID"                      CHAR(50) NOT NULL INLINE 50 PREFIX 8
   ,"WPKFormID"                      CHAR(50) NOT NULL INLINE 50 PREFIX 8
   ,"Name"                           CHAR(50) NULL
   ,"ItemType"                       CHAR(20) NOT NULL
   ,"DataType"                       CHAR(1) NULL
   ,"DataLength"                     SMALLINT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"CanView"                        CHAR(100) NULL INLINE 100 PREFIX 8
   ,"CanEdit"                        CHAR(100) NULL INLINE 100 PREFIX 8
   ,"Required"                       CHAR(50) NULL
   ,"DefaultValue"                   CHAR(50) NULL
   ,"Mask"                           CHAR(50) NULL
   ,"DisplayFormat"                  CHAR(50) NULL
   ,"Descriptor"                     long VARCHAR NULL
   ,"ComplexDataUpdateCommand"       long VARCHAR NULL
   ,"PickList"                       long VARCHAR NULL
   ,"CheckValues"                    CHAR(20) NULL
   ,"Sortable"                       tinyint NULL DEFAULT 0
   ,"SortExpression"                 CHAR(100) NULL
   ,"BackColour"                     CHAR(100) NULL INLINE 100 PREFIX 8
   ,"FontColour"                     CHAR(100) NULL INLINE 100 PREFIX 8
   ,"CaptionBackColour"              CHAR(100) NULL INLINE 100 PREFIX 8
   ,"CaptionFontColour"              CHAR(100) NULL INLINE 100 PREFIX 8
   ,"Image"                          CHAR(50) NULL
   ,"Indent"                         SMALLINT NULL DEFAULT 0
   ,"DisplaySize"                    SMALLINT NULL DEFAULT 10
   ,"Expanded"                       CHAR(50) NULL
   ,"IDforVideoRecordType"           CHAR(50) NULL
   ,"ComboScript"                    long VARCHAR NULL
   ,"ButtonGroup"                    SMALLINT NULL
   ,PRIMARY KEY ("WPKViewItemID" ASC,"WPKViewID" ASC,"WPKFormID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."ItemType" IS 
	'DataField,Combo,EditCombo,LookupCombo,CheckList,RadioList,CheckBox,SpinEdit,Question,Phone,Concatenated,View,PanelControl,Button,Ellipsis'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."DataType" IS 
	'String, Date, Time, Integer, Number, timestamP, Memo'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."DataLength" IS 
	'For String fields'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."SortOrder" IS 
	'Orders the items in a view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."CanView" IS 
	'Literal boolean or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."CanEdit" IS 
	'Literal boolean or switch. If blank inherits from view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Required" IS 
	'Literal boolean or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."DefaultValue" IS 
	'Connection Attributes e.g C_Unique, C_Date, C_Time, C_DateTime, C_UserID, C_LoginName, L_literal or other switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Mask" IS 
	'Literal string or switch. Use *! for uppercase'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."DisplayFormat" IS 
	'Literal string or switch - applies to numbers, dates, times etc but not strings'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Descriptor" IS 
	'table.column, sql expression, control name, button command, view id, concatenation expression, Questions- taglocation;tagid;id  {} substitutions apply'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."ComplexDataUpdateCommand" IS 
	'update table set.... or call chgdata(....   Uses normal params + ::Value and for checklists also ::CheckListID'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."PickList" IS 
	'Literal string or switch. For Combo,EditCombo,LookupCombo,CheckList,RadioList'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."CheckValues" IS 
	'For CheckBox and CheckList   checked;unchecked   Default 1;0'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Sortable" IS 
	'0 no, 1 yes, 2 default order (The first 2 is the starting order otherwise the first 1)'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."SortExpression" IS 
	'Default is the column itself'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."BackColour" IS 
	'Literal integer or switch. If blank inherits from view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."FontColour" IS 
	'Literal integer or switch. If blank inherits from view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."CaptionBackColour" IS 
	'Literal integer or switch. If blank inherits from view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."CaptionFontColour" IS 
	'Literal integer or switch. If blank inherits from view'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Image" IS 
	'For buttons. Literal string or switch pointing to the wpkimageid'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Indent" IS 
	'Controls indent levels in Inspectors and also the left indent on controls like buttons'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."DisplaySize" IS 
	'Col width for Grids, cell height for inspectors, width for buttons'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."Expanded" IS 
	'Literal boolean or switch. Expanded state of inspector node. Blank for NO and leave unchanged on refresh'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."IDforVideoRecordType" IS 
	'Marks this column as the ID to be used to respond to a video movement request for this record type'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."ComboScript" IS 
	'Button script executed on combo close up'
GO
 
 
COMMENT ON COLUMN "pears"."WPKViewItem"."ButtonGroup" IS 
	'Set >0 for stay down buttons. If >=100 then AllowAllUp is set - useful for individual state buttons'
GO
 
 
COMMENT ON TABLE "pears"."WPKViewItem" IS 
	'Woodpecker View Item definitions.'
GO
 
 
ALTER TABLE "pears"."WPKViewItem"
    ADD NOT NULL FOREIGN KEY "ViewK" ("WPKViewID" ASC,"WPKFormID" ASC)
    REFERENCES "pears"."WPKView" ("WPKViewID","WPKFormID")
    ON DELETE CASCADE
GO
 
 
CREATE TRIGGER "TrackViewItemChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKViewItem"
REFERENCING NEW AS "itm"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('F',"itm"."WPKFormID")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKViewItem"."TrackViewItemChange" IS 
{CREATE TRIGGER TrackViewItemChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKViewItem
REFERENCING NEW AS itm
FOR each ROW
BEGIN
  CALL WPKTrackChange('F',itm.WPKFormID)
END
}
GO