FILL-WHERE-STRING attribute

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 Unknown value (?).

Notes:

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.

See also:

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