The current WHERE expression for a data-source query, beginning with the keyword WHERE, and not including the prior FOR EACH phrase of an OPEN QUERY statement.

Data type: CHARACTER

Access: Readable/Writeable

Applies to: Data-source object handle

You can use this attribute to override the existing WHERE expression in the query for the data-source object during a FILL( ) operation. The default is the null value.

Note:

You can also modify the query on an associated data-relation using the WHERE-STRING attribute.

The NAME attribute of the Temp-table object handle is writeable for dynamic and AVM-generated temp-tables. You might need to update a FILL-WHERE-STRING that references a renamed temp-table with new strings using the new table name.

Note: The FILL-WHERE-STRING attribute of the data source object only applies to the default data source query. It does not apply when a named query is specified using the QUERY attribute.

See also

DEFINE DATA-SOURCE statement, FILL( ) method, WHERE-STRING attribute