pears.WPKForm

Woodpecker Form definitions.

• WPKFormID

• No outgoing foreign keys found.

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKForm"
-- Table comment: Woodpecker Form definitions.
-- Statement count: 20
 
CREATE TABLE "pears"."WPKForm" (
    "WPKFormID"                      CHAR(50) NOT NULL INLINE 50 PREFIX 8
   ,"Name"                           CHAR(50) NOT NULL
   ,"FormType"                       CHAR(20) NOT NULL
   ,"VideoRecordType"                CHAR(50) NULL
   ,"Notes"                          long VARCHAR NULL
   ,"FormClass"                      CHAR(50) NULL
   ,"FormSwitches"                   long VARCHAR NULL
   ,"MasterView"                     CHAR(50) NULL
   ,"Caption"                        CHAR(100) NULL
   ,"Colour"                         CHAR(100) NULL INLINE 100 PREFIX 8
   ,"DefaultLayout"                  CHAR(50) NULL
   ,"DefaultDetailView"              CHAR(50) NULL
   ,"CanEdit"                        CHAR(100) NULL INLINE 100 PREFIX 8
   ,"FormWidth"                      CHAR(50) NULL
   ,"FormHeight"                     CHAR(50) NULL
   ,"FormTop"                        CHAR(50) NULL
   ,"FormLeft"                       CHAR(50) NULL
   ,"UpdateCallerFlag"               tinyint NULL DEFAULT 0
   ,"TestSwitches"                   long VARCHAR NULL
   ,PRIMARY KEY ("WPKFormID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormType" IS 
	'Single or Multiple. Defines whether there is a single master record for the form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."VideoRecordType" IS 
	'Literal string or switch. The identity used by the video buttons when requesting a video movement from the parent form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormClass" IS 
	'Identifies a defined form in the application. Blank for the default form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormSwitches" IS 
	'List (1 per line) of the names of the positional form switches. Un-named ones can be referenced by number'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."MasterView" IS 
	'Literal string or switch. Points to the primary view for editing and entering records on single record forms. Useful for caption, edit rights, colour etc'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."Caption" IS 
	'Literal string or switch. May use e.g. Q_Caption to reference control query, or New {G_CoTitle}'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."Colour" IS 
	'Literal integer or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."DefaultLayout" IS 
	'Literal string or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."DefaultDetailView" IS 
	'Literal string or switch. Will be shown in bottom panel IF can be viewed and can be selected from current layout'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."CanEdit" IS 
	'Literal boolean or switch - often a R_ role switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormWidth" IS 
	'Literal integer or switch. Default taken from form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormHeight" IS 
	'Literal integer or switch. Default taken from form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormTop" IS 
	'Literal integer or switch. Default taken from form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."FormLeft" IS 
	'Literal integer or switch. Default taken from form'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."UpdateCallerFlag" IS 
	'0 Never 1 Always 2 New records only'
GO
 
 
COMMENT ON COLUMN "pears"."WPKForm"."TestSwitches" IS 
	'Passed into form when testing. One switch per line'
GO
 
 
COMMENT ON TABLE "pears"."WPKForm" IS 
	'Woodpecker Form definitions.'
GO
 
 
CREATE TRIGGER "WPKTrackFormChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKForm"
REFERENCING NEW AS "frm"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('F',"frm"."WPKFormID")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKForm"."WPKTrackFormChange" IS 
{CREATE TRIGGER WPKTrackFormChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKForm
REFERENCING NEW AS frm
FOR each ROW
BEGIN
  CALL WPKTrackChange('F',frm.WPKFormID)
END
}
GO