Parameters from
the
SQL where clause are listed in the XPath
expression table. You can edit the XPath expressions to refine the
input, for example to add a specific array index for a dragged repeating
field. A default
SQL where clause is created
for you, which selects all rows in your selected database table.
Note: If
you edit the text of the
SQL where clause directly:
- Ensure that the case of your table and column names match that
of your database.
- Avoid the use of double-quotes around table and column names.
- Use only the supported SQL keywords that are presented in the
Operators pane.
- Ensure that each parameter placeholder is inserted
as a question mark followed by an optional unique number and a space
character, and also ensure that each parameter placeholder is defined
with an XPath expression in the parameter table below the SQL where
clause.