Versions Compared

Old Version 7

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Jessica Tomkins

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

"value": Sets the initialization value for the current element.

Subfile Settings

"display subfile record number": This property identifies tells the scrollbar position when the subfile is first displayed."position at top": When this property is set to true, the subfile record identified by the "subfile record number" property will display in the top row of the gridsystem when to display grid records. It represents the SFLDSP keyword.

  • Possible choices: "true", "false"

"display control record": This property tells the system when to display the subfile control record. It represents the SFLDSPCTL keyword.

  • Possible choices: "true", "false"

"place cursorinitialize subfile": When this property is set to true, the cursor is placed in the subfile record identified by the contents of the "subfile record number" property. The cursor is positioned at the first input-capable field in the subfile recordThis property tells the system to initialize all records within the subfile. It represents the SFLINZ keyword.

  • Possible choices: "true", "false"

"subfile endrecords not active": This property is used to indicate that a subfile with a paging bar has loaded all of its recordscan be used together with the "initialize subfile" property to initialize a subfile with no active records. It represents the SFLRNA keyword.

  • Possible choices: "true", "false"

"delete subfile next changed": This property is used to forces the user to correct program-detected typing errors in subfile records. The program can cause a record to be changed so that a get-next-changed operation must read the record again': This property tells the system when to delete the subfile area. It represents the SFLDLT keyword.

  • Possible choices: "true", "false"

"cursor record numberclear subfile": This property can be bound to a numeric field, which will return the relative record number of the record on which the cursor is located."cursor progression": This property determines the tab order for input elements within the subfiletells the system when to clear all records from the subfile. It represents the SFLCLR keyword.

  • Possible choices: "left to righttrue", "top to bottomfalse"

"subfile return rrnsize": This property can be bound to a numeric fieldrepresents the SFLSIZ keyword, which will return specifies the relative record number of the top visible record within a grid.

"subfile changed": Specifies a response indicator that is set on if the input data within the subfile is modified.

Font and Text

"font family": The font face for the text inside the grid. To define a different font for each grid column, select <i>Other...</i> and specify a comma separated list of fonts.

  • Possible choices: "Arial", "Consolas", "Courier New", "Fantasy", "Georgia", "Monospace", "Tahoma", "Times New Roman", "Sans-Serif", "Serif", "Trebuchet MS", "Verdana", "Other..."

"font size": The size of the text inside the grid. To specify a different font size for each grid column, select <i>Other...</i> and specify a comma separated list of font sizes.

  • Possible choices: "8px", "9px", "10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "21px", "22px", "23px", "24px", "25px", "26px", "27px", "28px", "29px", "30px", "Other..."

"font style": The style of the font in the grid. To specify a different font style records that can be placed into the subfile. However, if you program places a record with a relative record number larger than the SFLSIZ value into the subfile, the subfile is automatically extended to contain it (up to a maximum of 9999 records). If this property is not specified, the subfile page value plus one is used. The subfile page value is determined from the "number of rows" property minus the header row if it is present.

"subfile record number": This property identifies the scrollbar position when the subfile is first displayed. It represents the SFLRCDNBR keyword.

"position at top": When this property is set to true, the subfile record identified by the "subfile record number" property will display in the top row of the grid.

  • Possible choices: "true", "false"

"place cursor": When this property is set to true, the cursor is placed in the subfile record identified by the contents of the "subfile record number" property. The cursor is positioned at the first input-capable field in the subfile record.

  • Possible choices: "true", "false"

"subfile end": This property is used to indicate that a subfile with a paging bar has loaded all of its records. It represents the SFLEND keyword.

  • Possible choices: "true", "false"

"subfile next changed": This property is used to forces the user to correct program-detected typing errors in subfile records. The program can cause a record to be changed so that a get-next-changed operation must read the record again.

  • Possible choices: "true", "false"

"cursor record number": This property can be bound to a numeric field, which will return the relative record number of the record on which the cursor is located.

"cursor progression": This property determines the tab order for input elements within the subfile. It represents the SFLCSRPRG keyword.

  • Possible choices: "left to right", "top to bottom"

"subfile return rrn": This property can be bound to a numeric field, which will return the relative record number of the top visible record within a grid. It represents the SFLSCROLL keyword.

"subfile changed": Specifies a response indicator that is set on if the input data within the subfile is modified.

Message Subfile Settings

"subfile message key": This property specifies a field that is used to select messages from a program message queue for display. Your program places a message reference key in this field. The property represents the SFLMSGKEY keyword on a subfile record format.

"subfile program message queue": This property specifies a field that contains the name of the program message queue used to build a message subfile. It represents the SFLPGMQ keyword on a subfile record format.

"subfile control program message queue": This property specifies a field that contains the name of the program message queue used to build a message subfile when used in conjunction with the subfile initialize property. It represents the SFLPGMQ keyword on a subfile control record format.

Font and Text

"font family": The font face for the text inside the grid. To define a different font for each grid column, select <i>Other...</i> and specify a comma separated list of font stylesfonts.

  • Possible choices: "Arial", "normalConsolas", "italicCourier New", "obliqueFantasy", "Other..."

"font variant": Normal or <span style='font-variant:small-caps;'>small caps</span>. Small caps shows the text with all caps but same height as a lower case letter.

  • Possible choices: "normal", "small-capsGeorgia", "Monospace", "Tahoma", "Times New Roman", "Sans-Serif", "Serif", "Trebuchet MS", "Verdana", "Other..."

"font weightsize": Specifies the weight The size of the font text inside the grid. To specify a different font weight size for each grid column, select <i>Other...</i> and specify a comma separated list of font weightssizes.

  • Possible choices: "normal8px", "bolder9px", "bold10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "lighter21px", "10022px", "20023px", "30024px", "40025px", "50026px", "60027px", "70028px", "80029px", "90030px", "Other..."

"letter spacingfont style": Spacing between each letter of a word The style of the font in the grid. To specify a different value font style for each grid column, select <i>Other...</i> and specify a comma separated list of valuesfont styles.

  • Possible choices: "normal", "-3pxitalic", "-2pxoblique", "-1px", "0px", "1px", "2px", "3px", "4px", "5px", "6px", "7px", "8px", "9px", "10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "Other..."

...

  • Other..."

"font variant": Normal or <span style='font-variant:small-caps;'>small caps</span>. Small caps shows the text with all caps but same height as a lower case letter.

  • Possible choices: "normal", "small-caps", "Other..."

"font weight": Specifies the weight of the font inside the grid. To specify a different font weight for each grid column, select <i>Other...</i> and specify a comma separated list of font weights.

  • Possible choices: "normal", "bolder", "bold", "lighter", "100", "200", "300", "400", "500", "600", "700", "800", "900", "Other..."

"letter spacing": Spacing between each letter of a word. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "leftnormal", "right-3px", "center-2px", "justify-1px", "Other..."

"text decoration": Decoration of the text inside the grid. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "none", "underline", "overline", "line-through", "Other..."

"text transform": Transforms the default formatting of the text inside the grid. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "capitalize", "uppercase", "lowercase", "none0px", "1px", "2px", "3px", "4px", "5px", "6px", "7px", "8px", "9px", "10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "Other..."

"word spacingtext align": Spacing between each word in the Alignment of text inside cells of the grid element. To specify a different value alignment option for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "normalleft", "-3pxright", "-2pxcenter", "-1pxjustify", "0px", "1px", "2px", "3px", "4px", "5px", "6px", "7px", "8px", "9px", "10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "21px", "22px", "23px", "24px", "25px", "Other..."

Header

"has header": Determines whether the grid has a header row.

  • Possible choices: "true", "false"

"header height": Specifies the height of the header row. This can also be specified by dragging the grid's top border with the mouse.

"header font family": The font face for the text inside the grid header row. To define a different font for each grid column, select <i>Other...</i> and specify a comma separated list of fonts.

  • Possible choices: "Arial", "Consolas", "Courier New", "Fantasy", "Georgia", "Monospace", "Tahoma", "Times New Roman", "Sans-Serif", "Serif", "Trebuchet MS", "VerdanaOther..."

"text decoration": Decoration of the text inside the grid. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "none", "underline", "overline", "line-through", "Other..."

"text transform": Transforms the default formatting of the text inside the grid. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "capitalize", "uppercase", "lowercase", "none", "Other..."

"word spacing": Spacing between each word in the cells of the grid. To specify a different value for each grid column, select <i>Other...</i> and specify a comma separated list of values.

  • Possible choices: "normal", "-3px", "-2px", "-1px", "0px", "1px", "2px", "3px", "4px", "5px", "6px", "7px", "8px", "9px", "10px", "11px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "21px", "22px", "23px", "24px", "25px", "Other..."

Header

"has header font size": The size of the text inside Determines whether the grid has a header row. To specify a different font size for each grid column, select <i>Other...</i> and specify a comma separated list of font sizes.

  • Possible choices: "8pxtrue", "9pxfalse",

"

...

header height": Specifies the height of the header row. This can also be specified by dragging the grid's top border with the mouse.

"header font family": The font face for the text inside the grid header row. To define a different font for each grid column, select <i>Other...</i> and specify a comma separated list of fonts.

  • Possible choices: "Arial", "Consolas", "Courier New", "Fantasy", "Georgia", "Monospace", "Tahoma", "Times New Roman", "Sans-Serif", "Serif", "Trebuchet MS", "Verdana", "Other..."

"header font stylesize": Specifies the style The size of the font text inside the grid header row. To specify a different font style size for each grid column, select <i>Other...</i> and specify a comma separated list of font stylessizes.

  • Possible choices: "normal8px", "italic9px", "oblique10px", "Other..."

"header font weight": Specifies the weight of the font inside the grid header row. To specify a different font weight for each grid column, select <i>Other...</i> and specify a comma separated list of font weights.

  • Possible choices: "normal", "bolder", "bold", "lighter", "100", "200", "300", "400", "500", "600", "700", "800", "90011px", "12px", "13px", "14px", "15px", "16px", "17px", "18px", "19px", "20px", "21px", "22px", "23px", "24px", "25px", "26px", "27px", "28px", "29px", "30px", "Other..."

"header text alignfont style": Alignment of text inside the cells of Specifies the style of the font inside the grid header row. To specify a different alignment option font style for each cellgrid column, select <i>Other...</i> and specify a comma separated list of valuesfont styles.

  • Possible choices: "leftnormal", "rightitalic", "center", "justifyoblique", "Other..."

"header font colorweight": Defines Specifies the color weight of the text font inside the grid header row. To define specify a different color font weight for each grid cell in the header row, specify column, select <i>Other...</i> and specify a comma separated list of color valuesfont weights.

  • Possible choices: "

...

"header image": Defines a repeating background image for the header row.

"column headings": Specifies a comma separated list of heading text for each column of the grid.

Colors

...

  • normal", "bolder", "bold", "lighter", "100", "200", "300", "400", "500", "600", "700", "800", "900", "Other..."

"header text align": Alignment of text inside the cells of the grid header row. To specify a different alignment option for each cell, select <i>Other...</i> and specify a comma separated list of color values."odd row backgroundvalues.

  • Possible choices: "left", "right", "center", "justify", "Other..."

"header font color": Defines the background color of the odd rows in the gridtext inside the header row. To define a different color for each grid columncell in the header row, specify a comma separated list of color values.

"even row font colorheader background": Defines the background color of text inside the even rows of the gridthe header row. To define a different color for each grid columncell in the header row, specify a comma separated list of color values.

"even row backgroundheader image": Defines a repeating background image for the header row.

"column headings": Specifies a comma separated list of heading text for each column of the grid.

Colors

"odd row font color": Defines the background color of text inside the even odd rows in of the grid. To define a different color for each grid column, specify a comma separated list of color values.

"odd row font colorbackground":  Defines the background color of text in an individual row. You can define a dynamic color for each record by binding this property to a field.

"row background": Defines the background color of an individual row. You can define a dynamic background color for each record by binding this property to a field.

"hover the odd rows in the grid. To define a different color for each grid column, specify a comma separated list of color values.

"even row font color": Defines the color of text when the user hovers the mouse cursor over a grid rowinside the even rows of the grid. To define a different color for each grid column, specify a comma separated list of color values.

"hover even row background": Defines the background color of a grid row when the user hovers the mouse cursor over itthe even rows in the grid. To define a different color for each grid column, specify a comma separated list of color values.

"selection row font color": Defines the color of text when the user selects a grid rowin an individual row. You can define a dynamic color for each record by binding this property to a field.

"selection row background": Defines the background color of a grid row when the user selects it.

Grid Settings

"number of rows": Specifies the number of rows in the grid, including the header row.

"number of columns": Specifies the number of columns in the grid.

"row height": Specifies the height that will be applied to each row, not including the header row. This can also be controlled by resizing the grid with the mouse.

"hover effect": Determines whether the grid rows will be highlighted an individual row. You can define a dynamic background color for each record by binding this property to a field.

"hover font color": Defines the color of text when the user hovers the mouse cursor over a grid row. To define a different color for each grid column, specify a comma separated list of color values.

"hover background": Defines the background color of a grid row when the user hovers the mouse cursor over them.

  • Possible choices: "true", "false"

"hover image": Defines a repeating cell background image for the hover effect.

"row selection": Determines if rows within the grid can be selected by the user with a click of the mouse. <br/><br/>Possible values are: <br/><br/><b>none</b> - rows cannot be selected <br/><br/><b>single</b> - only one row can be selected <br/><br/><b>multiple (simple)</b> - multiple rows can be selected by simply clicking on the rows <br/><br/><b>multiple (extended)</b> - multiple rows can be selected with the use of the Shift and Ctrl keysit. To define a different color for each grid column, specify a comma separated list of color values.

"selection font color": Defines the color of text when the user selects a grid row.

"selection background": Defines the background color of a grid row when the user selects it.

Grid Settings

"number of rows": Specifies the number of rows in the grid, including the header row.

"number of columns": Specifies the number of columns in the grid.

"row height": Specifies the height that will be applied to each row, not including the header row. This can also be controlled by resizing the grid with the mouse.

"hover effect": Determines whether the grid rows will be highlighted when the user hovers the mouse over them.

  • Possible choices: "true", "false"

"hover image": Defines a repeating cell background image for the hover effect.

"row selection": Determines if rows within the grid can be selected by the user with a click of the mouse. <br/><br/>Possible values are: <br/><br/><b>none</b> - rows cannot be selected <br/><br/><b>single</b> - only one row can be selected <br/><br/><b>multiple (simple)</b> - multiple rows can be selected by simply clicking on the rows <br/><br/><b>multiple (extended)</b> - multiple rows can be selected with the use of the Shift and Ctrl keys

  • Possible choices: "none", "single", "multiple (simple)", "multiple (extended)"

"selection field": This property must be bound to an indicator or a character field, which will be used to both set and return the selected state on each record. If a character field is specified, the selection value property will be used to populate the field when a row is selected.

"selection value": Specifies the value used to populate the selection field when a grid row is selected.

"selection image": Defines a repeating cell background image for row selection.

"column widths": Specifies a comma separated list of column widths for this grid.

"scrollbar": Determines the type of vertical scrollbar used to scroll through records within the grid. A sliding scrollbar scrolls freely, while a paging scrollbar scrolls one page of records at a time only.

  • Possible choices: "none", "sliding", "paging"

"scroll tool tip": Determines if the row number or the row number range should be displayed in a tool tip when the user scrolls through the data in the grid.

  • Possible choices: "none", "singlerow number", "multiple (simple)", "multiple (extended)row range"

"selection fieldpropagate scroll events": This property must be bound to an indicator or a character field, which will be used to both set and return the selected state on each record. If a character field is specified, the selection value property will be used to populate the field when a row is selected.

"selection value": Specifies the value used to populate the selection field when a grid row is selected.

"selection image": Defines a repeating cell background image for row selection.

"column widths": Specifies a comma separated list of column widths for this grid.

"scrollbar": Determines the type of vertical scrollbar used to scroll through records within the grid. A sliding scrollbar scrolls freely, while a paging scrollbar scrolls one page of records at a time only When this property is false (which is the default) the grid handles any scroll wheel or swipe events sent to it so that they scroll the grid, but not the window that the grid is placed inside. If you enable this property, these events will be propagated, which allows mouse wheel and swipe events to scroll the grid's parent window.

  • Possible choices: "true", "false"

"sortable columns": Enables column sorting. If set to true, the user will be able to click on the column headings to resort the data.

  • Possible choices: "nonetrue", "sliding", "pagingfalse"

"scroll tool tip": Determines if the row number or the row number range should be displayed in a tool tip when the user scrolls through the data in the griddefault sort order": Specifies the default order for sortable columns. When the user clicks a column, the default sort order is used initially. To provide a different sort order for each grid column, select <i>Other...</i> and specify a comma separated list. Entries in the list can be abbreviated using the letter A for Ascending and D for Descending.

  • Possible choices: "noneAscending", "row numberDescending", "row range"

"sortable columns": Enables column sorting. If set to true, the user will be able to click on the column headings to resort the data.

  • Possible choices: "true", "false"

"default sort order": Specifies the default order for sortable columns. When the user clicks a column, the default sort order is used initially. To provide a different sort order for each grid column, select <i>Other...</i> and specify a comma separated list. Entries in the list can be abbreviated using the letter A for Ascending and D for Descending.

  • Possible choices: "Ascending", "Descending", "Other..."

...

  • Other..."

"initial sort column": This property specifies the column used to for inital sorting. Each grid column is identified by a sequential index, starting with 0 for the first column, 1 for the second column, and so on. If the property is omitted or set to blanks, sorting is not initiated when the grid is first rendered.

"initial sort field": This property specifies the field name used to identify the column for initial sorting. If this property and the "initial sort column" property are omitted or set to blanks, sorting is not initiated when the grid is first rendered.

"column sort response": Specifies a response variable for server-side sorting. If omitted, client-side sorting is used. The response is a numeric value that represents a column in the grid. Each grid column is identified by a sequential index, starting with 0 for the first column, 1 for the second column, and so on. If the property is omitted or set to blanks, sorting is not initiated when the grid is first rendered."initial sort field": This property specifies the field name used to identify the column for initial sorting. If this property and It is the responsibility of the program to keep track of the sort direction, and to display an up or down arrow in the appropriate column using the "initial sort column" property are omitted or set to blanks, sorting is not initiated when the grid is first rendered."column sort response": Specifies a response variable " and "default sort order" properties.

"Field Name Sort Response": Specifies a response variable to receive a field name used for server-side sorting. If omitted, client-side sorting is used. The response is a numeric value that represents a column in the grid. Each grid column is identified by a sequential index, starting with 0 for the first column, 1 for the second column, and so onrepresents the name of the field bound to the first widget in a column of the grid. It is the responsibility of the program to keep track of the sort direction, and to display an up or down arrow in the appropriate column using the "initial sort columnfield" and "default sort order" properties.

...

  • Possible choices: "true", "false"

"csv xlsx export": Displays a link allowing the user to export grid data to Excel using the XLSX format.

  • Possible choices: "true","false"

"export file name": Defines the name of the download file used to export grid data to CSV formator XLSX formats. The .xlsx or .csv extension is automatically appended to the name. If omitted, the record format name is used.

...

"database file": Database file to use for a grid that is tied directly to a database. You can specify a 'database file' or 'library/database file'. If library is omitted, the session's library list is used."database fields": A set of database field names library list is used.

"database fields": A set of database field names to use to retrieve the data for a database-driven grid. The field names should be comma separated.

"selection criteria": Optional expression identifying which records should be retrieved from the database file.

"order by": Optional expression identifying which fields determine the order of the records retrieved from the database file.

"custom sql": Specifies an sql statement to use to retrieve the data records for a database-driven grid. The field names should be comma separated.

"selection criteria": Optional expression identifying which records should be retrieved from the database file.

"order by": Optional expression identifying which fields determine the order of the records retrieved from the database file.

"custom sql": Specifies an sql statement to use to retrieve the records for a database-driven gridallow any select statement": Allows any valid SELECT SQL statement. If this is false (default), a row count is retrieved by running SELECT COUNT( *) FROM (your-custom-sql-property), so your "custom sql" property must work with that syntax. This prevents the use of common table expressions, the optimize clause, and a few other things. If set to true, the row count will be determined by running your statement as-is and looping through all rows to count them. Note: False performs better, but true allows a wider variety of SQL statements.

"parameter value": Value for parameter marker in "selection criteria" or "custom sql" property. Parameter markers are specified using a question mark. Profound UI will accept values from the client for any parameter marker values which are not bound to program fields. Parameter markers are numbered in order of occurence, from left to right. To specify multiple parameter marker values, right-click the property and select Add Another Parameter Value.Value.

"data url": Sets the url to a Web service that returns JSON data for a database-driven grid.

"data transform function": The name of a JavaScript to be called to process the results of the "data url" : Sets the url to a Web service that returns JSON data for a database-driven gridprogram. This can be used to transform data from the program into the format expected by the grid widget.

Position

"left": Represents the x-coordinate of the current element.

...

"tool tip": Defines the text to appear in a tool tip when the user hovers the mouse over this elementhovers the mouse over this element.

"user defined data": Specifies user-defined general purpose data associated with the widget. To provide multiple user defined data values, right-click the property and select Add Another User Defined Value.

"visibility": Determines whether the element is visible or hidden.

  • Possible choices: "hidden", "visible"

Events

"ondbload": Initiates a client-side script when database data is loaded for a database-driven widget. An object named response will be defined that contains:

  • success: boolean true/false
  • id: the widget id
  • error: an object with "id", "text" and "text2" fields containing the error.

"onfilterchange": Initiates a client-side script when the filter has changed. 

...