pears.WPKLayout

Woodpecker Layout definitions.

• WPKLayoutID, WPKFormID

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKLayout"
-- Table comment: Woodpecker Layout definitions.
-- Statement count: 16
 
CREATE TABLE "pears"."WPKLayout" (
    "WPKLayoutID"                    CHAR(20) NOT NULL
   ,"WPKFormID"                      CHAR(50) NOT NULL INLINE 50 PREFIX 8
   ,"Name"                           CHAR(50) NOT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"CanSelect"                      CHAR(100) NULL INLINE 100 PREFIX 8
   ,"TopLeftView"                    CHAR(50) NULL
   ,"TopRightView"                   CHAR(50) NULL
   ,"MenuWidth"                      CHAR(50) NULL
   ,"TopSplitPercent"                CHAR(50) NULL
   ,"MiddleSplitPercent"             CHAR(50) NULL
   ,"Image"                          CHAR(50) NULL
   ,"Wizard"                         tinyint NULL DEFAULT 0
   ,"WizardFinishScript"             long VARCHAR NULL
   ,"ShowMenuImages"                 CHAR(50) NULL
   ,PRIMARY KEY ("WPKLayoutID" ASC,"WPKFormID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."SortOrder" IS 
	'Orders the lists on the outlook bar'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."CanSelect" IS 
	'Literal boolean or switch controlling availability in outlook bar. If switched off can still be used explicitly or as form default'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopLeftView" IS 
	'Literal string or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopRightView" IS 
	'Literal string or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."MenuWidth" IS 
	'Literal integer or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopSplitPercent" IS 
	'Literal integer or switch. Default 50%'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."MiddleSplitPercent" IS 
	'Literal integer or switch. Default 50%'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."Image" IS 
	'Literal string or switch pointing to the wpkimageid to be used for the group button on the outlook bar'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."Wizard" IS 
	'The layout behaves as a wizard with the layout views as pages'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."WizardFinishScript" IS 
	'Invoked on clicking Finish in wizard. If not specified defaults to standard save and refresh'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."ShowMenuImages" IS 
	'Literal boolean or switch enabling images on the outlook bar'
GO
 
 
COMMENT ON TABLE "pears"."WPKLayout" IS 
	'Woodpecker Layout definitions.'
GO
 
 
ALTER TABLE "pears"."WPKLayout"
    ADD NOT NULL FOREIGN KEY "WPKForm" ("WPKFormID" ASC)
    REFERENCES "pears"."WPKForm" ("WPKFormID")
    ON DELETE CASCADE
GO
 
 
CREATE TRIGGER "TrackLayoutChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKLayout"
REFERENCING NEW AS "lay"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('F',"lay"."WPKFormID")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKLayout"."TrackLayoutChange" IS 
{CREATE TRIGGER TrackLayoutChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKLayout
REFERENCING NEW AS lay
FOR each ROW
BEGIN
  CALL WPKTrackChange('F',lay.WPKFormID)
END
}
GO