ui-dt-textarea.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 129 行

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'Text Area'
 ,'Text area for larger string values<BR><BR>Translates to a < TEXTAREA > HTML tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'ALIGN'
 ,'Vertical Alignment'
 ,'Vertical alignment of the text in the text area<BR><BR>Translates to ALIGN attribute of HTML < TEXTAREA > tag.<BR>Value can be TOP, MIDDLE, or BOTTOM.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'ANCHOR_HREF_DEF'
 ,'Anchor (Link) Reference Definition'
 ,'Anchor (Link) Reference Definition<BR><BR>If this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.<BR><BR>Contents must be a semicolon-delimited list of attribute names from the listed entity.<BR>Literal strings may also be embedded with quotes around them.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'ANCHOR_TARGET'
 ,'Anchor (Link) Target'
 ,'Anchor (Link) Target<BR><BR>If this parameter and the ANCHOR_HREF_DEF parameter are set, the field will be displayed as an HTML < A > tag when in read-only mode, and the value of this parameter will be used as the value for the TARGET attribute of the < A > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'CLASS'
 ,'Class'
 ,'Style class<BR><BR>Defines what style from the style sheet to assign to the CLASS attribute of the < INPUT > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'COLS'
 ,'Number of Columns'
 ,'Number of columns in text area<BR><BR>Translates to COLS attribute of HTML < TEXTAREA > tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'DISABLED'
 ,'Disabled'
 ,'Disabled<BR><BR>Translates to DISABLED attribute of HTML < TEXTAREA > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'READONLY'
 ,'Read Only'
 ,'Read only<BR><BR>Translates to READONLY attribute of HTML < TEXTAREA > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'ROWS'
 ,'Number of Rows'
 ,'Number of rows in text area<BR><BR>Translates to ROWS attribute of HTML < TEXTAREA > tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'TEXTAREA'
 ,'WRAP'
 ,'Word Wrap'
 ,'Word wrap<BR><BR>Controls how text is wrapped within the text area.<BR>Translates to WRAP attribute of HTML < TEXTAREA > tag.<BR>Value can be OFF, PHYSICAL, or VIRTUAL'
);