Details

    • Type: Bug
    • Status: Applied
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.2
    • Component/s: None
    • Labels:
      None
    • Proposal:
      Hide

      Add reference to form:list-source-type

      Change description of form:list-source-type to

      The form:list-source-type attribute specifies how to populate the entry list in a combo box or list box control.

      The value of this attribute can be one of the following:

      • query: The list is populated by executing the query whose name is specified in the form:list-source attribute.
      • sql: The list is populated by executing the SQL statement specified in the form:list-source attribute.
      • sql-pass-through: The list is populated by executing the SQL statement specified in the form:list-source attribute. In contrast to the the sql attribute value, the SQL statement is passed directly to the database, without being interpreted and possibly modified by the implementation.
      • table: The list is populated using the content of a database table, whose name is specified in the form:list-source attribute.
      • table-fields: The list is populated using the field names of the database table specified in the form:list-source attribute.
      • value-list: The list is populated with values specified by the form:value attributes of the <form:option> child element. This setting is only applicable to list boxes.

      In all cases except value-list, the content of the form:list-source attribute is resolved relative to a database connection or database document. The <form:form> element containing the control defines this database connection or document via its form:datasource attribute.

      Show
      Add reference to form:list-source-type Change description of form:list-source-type to The form:list-source-type attribute specifies how to populate the entry list in a combo box or list box control. The value of this attribute can be one of the following: query: The list is populated by executing the query whose name is specified in the form:list-source attribute. sql: The list is populated by executing the SQL statement specified in the form:list-source attribute. sql-pass-through: The list is populated by executing the SQL statement specified in the form:list-source attribute. In contrast to the the sql attribute value, the SQL statement is passed directly to the database, without being interpreted and possibly modified by the implementation. table: The list is populated using the content of a database table, whose name is specified in the form:list-source attribute. table-fields: The list is populated using the field names of the database table specified in the form:list-source attribute. value-list: The list is populated with values specified by the form:value attributes of the <form:option> child element. This setting is only applicable to list boxes. In all cases except value-list, the content of the form:list-source attribute is resolved relative to a database connection or database document. The <form:form> element containing the control defines this database connection or document via its form:datasource attribute.
    • Resolution:
      Hide

      See Michael's final post.

      Show
      See Michael's final post.

      Description

      Transcribed from ODF_Revised_Editorial_Notes_27May2009.odt

      Original author: Patrick Durusau
      Section: 17.289 form:list-source

      Ed. Note Note the presumption of a data structure for the result set. What happens to subsequent columns? How does this interact with form:bound-column?

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Durusau
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: