columnname

The column with the RichText edit style
for which you want to get or set property values. You can specify
the column name or a pound sign (#) and the column number.

property

A property for the column’s
Edit style. Properties and their settings are listed in the table
below. The table identifies the properties you can use with DataWindowSyntaxFromSql.

value

The value to be assigned to the property.

AutoSelect

Whether to select the contents of the
column control automatically when it receives focus.

Values are:

• Yes – Select
  automatically.

• No – Do not select automatically.

You can use AutoSelect with DataWindowSyntaxFromSql.
The setting applies to all the columns in the generated syntax.

Painter: Auto Selection option

DisplayOnly

Whether the column is display only.

Values are:

• Yes – Do not
  allow the user to enter data; make the column display only.

• No – Allow the user to enter data.

Painter: Display Only option

For conditional control over column editing, use the Protect
property.

FocusRectangle

Whether a dotted rectangle (the focus
rectangle) surrounds the current row of the column when the column
has focus.

Values are:

• Yes – Display
  the focus rectangle.

• No – Do not display the focus rectangle.

You can use FocusRectangle with DataWindowSyntaxFromSql. The setting
applies to all the columns in the generated syntax.

Painter: Show Focus Rectangle option

Limit

A number specifying the maximum number
of characters (0 to 32,767) that the user can enter. 0 means unlimited.

Painter: Limit option.

NilIsNull

Whether to set the value of the column
control to null when the user leaves it blank.

Values are:

• Yes – Make
  the empty string null.

• No – Do not make the empty string null.

Painter: Empty String is Null option.

Required

Whether the column is required.

Values are:

• Yes – It is
  required.

• No – It is not required.

Painter: Required option.

VScrollBar

Whether a vertical scroll bar displays
in the column control.

Values are:

• Yes – Display
  vertical scroll bars.

• No – Do not display vertical scroll bars.

Painter: Vertical Scroll Bar option.