columnname

The name of the column for which you
want to get or set Prompt for Criteria properties.

property

A property for the Prompt for Criteria
dialog box. Properties and their settings are listed in the table
below.

value

A Yes or No value to be assigned to the
property. For Criteria properties, value cannot
be a DataWindow expression.

Dialog

Whether Prompt for Criteria is on for columnname.

Values are:

• Yes – Include columnname in
  the Prompt for Criteria dialog box.

• No – (Default) Do not include columnname in
  the Prompt for Criteria dialog box.

If the Dialog property is Yes for at least one column in the
DataWindow, then the DataWindow server displays the Prompt for Criteria dialog
box when the Retrieve method is called.

Painter: Column Specifications view, Prompt check box.

Override_Edit

Whether the user must enter data in the
Prompt for Criteria dialog box according to the edit style defined
for the column in the DataWindow object or be allowed to enter any
specifications in a standard edit control.

Values are:

• Yes – Allow
  the user to override the column’s edit style and enter
  data in a standard edit control.

• No – (Default) Constrain the user to the
  edit style for the column.

Painter: Properties view, General Tab, Override Edit option.

Required

Whether the user is restricted to the
equality operator (=) when specifying criteria in query
mode and in the Prompt for Criteria dialog box.

Values are:

• Yes – Require
  the user to use the equality operator only.

• No – (Default) Allow the user to use any
  relational operator, including =, <>, <, >, >=,
  and <=.

Painter: Properties view, General tab, Equality Required option.