[ http://tools.oasis-open.org/issues/browse/OFFICE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21573#action_21573 ]
Michael Brauer commented on OFFICE-2789:
----------------------------------------
The clue that even for form:command-type="query" or "table" a SQL statement is executed. We may amend the descriptions of the two values as follows:
- query: the command contains the name of query. The form retrieves *the query* and executes *its SQL statement*.
- table: the command contains a table name. The form *executes an SQL statement that* retrieves all of the data in the table.
With that it becomes clear that there is always a SQL statement, and we may amend the form:filter description as follows:
The form:filter attribute specifies a filter for the SQL clause determined by the form:command-type and form:comand attributes. If that
SQL statement contains already a filter (WHERE clause), the filter specified by the attribute value is is conjunctively added to the existing filter.
> 19.275 "The filter is conjunctively added..." ? How is "conjunctively added" different from "added?"
> ----------------------------------------------------------------------------------------------------
>
> Key: OFFICE-2789
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2789
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: Forms
> Affects Versions: ODF 1.2 CD 05
> Reporter: Patrick Durusau
> Fix For: ODF 1.2 CD 06
>
>
> 19.275 "The filter is conjunctively added..." ? How is "conjunctively added" different from "added?"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
