Edit.property

columnname

The column with the Edit 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 SyntaxFromSQL.

value

The value to be assigned to the property. For most Edit properties, you cannot specify a DataWindow expression. The exception is Edit.Format.

AutoHScroll

Whether the edit control scrolls horizontally automatically when data is entered or deleted. Values are:

• Yes — Scroll horizontally automatically.

• No — Do not scroll horizontally automatically.

You can use AutoHScroll with SyntaxFromSQL. The setting applies to all the columns in the generated syntax.

Painter: Auto Horz Scroll option.

AutoRetrieve

Whether an embedded DropDownDataWindow is retrieved automatically at the same time as the retrieve on the parent DataWindow. Values are:

• Yes — (Default) Child DataWindow automatically retrieved.

• No — Child DataWindow must be retrieved programmatically. A subsequent reset or retrieval on the parent does not reset the contents of the child DataWindow.

Painter: AutoRetrieve option for DropDownDataWindow controls.

AutoSelect

Whether to select the contents of the edit control automatically when it receives focus. Values are:

• Yes — Select automatically.

• No — Do not select automatically.

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

Painter: Auto Selection option.

AutoVScroll

Whether the edit box scrolls vertically automatically when data is entered or deleted. Values are:

• Yes — Scroll vertically automatically.

• No — Do not scroll vertically automatically.

You can use AutoVScroll with SyntaxFromSQL. The setting applies to all the columns in the generated syntax.

Painter: Auto Vert Scroll option.

Case

The case of the text in the edit control. Values are:

• Any — Character of any case allowed.

• Upper — Characters converted to uppercase.

• Lower — Characters converted to lowercase.

Painter: Case option.

CodeTable

Whether the column has a code table. Values are:

• Yes — Code table defined.

• No — No code table defined.

Painter: Use Code Table 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 — (Default) 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) will surround the current row of the column when the column has focus. Values are:

• Yes — (Default) Display the focus rectangle.

• No — Do not display the focus rectangle.

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

Painter: Show Focus Rectangle option.

Format

(exp) A string containing the display format of the edit control. The value for Format is quoted and can be a DataWindow expression.

Painter: Format option (do not use quotes around the value).

HScrollBar

Whether a horizontal scroll bar displays in the edit control. Values are:

• Yes — Display the horizontal scroll bar.

• No — Do not display the horizontal scroll bar.

Painter: Horz Scroll Bar option.

InputEditMode

When an editable column has focus, the SIP type on a Pocket PC or the input method edit mode on a Smartphone device. Values are:

• 0 — (Default) Does not change the current SIP type on a Pocket PC or the current edit mode on a Smartphone

• 1 — Numeric mode for a Smartphone

• 2 — T9 mode for a Smartphone

• 3 — Multipress lowercase mode for a Smartphone

• 4 — T9 uppercase mode for a Smartphone

• 5 — T9 first letter uppercase for a Smartphone

• 6 — Multipress uppercase mode for a Smartphone

• 7 — Multipress first letter uppercase for a Smartphone

• 11 — SIP Keyboard mode for a Pocket PC

• 12 — SIP Jot mode for a Pocket PC

• 13 — SIP Block mode for a Pocket PC

• 14 — SIP WordLogic mode for a Pocket PC

• 15 — SIP Transcriber mode for a Pocket PC (Using the Transcriber mode for a DataWindow text field leads to unpredictable results.)

• 16 — Fitaly SIP keyboard for a Pocket PC

Limit

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

Painter: Limit option.

Name

A string whose value is the name of the predefined edit style associated with the column. Named styles are defined in the Database painter and can be reused. Specifying a name that has not been previously defined associates the name with the column but does not define a new edit style.

Painter: Style Name option.

NilIsNull

Whether to set the value of the edit 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.

Password

Whether to assign secure display mode to the column. When the user enters characters, they display as asterisks (*) Values are:

• Yes — Assign secure display mode to the column.

• No — Do not assign secure-display mode to the column.

If you change the Password property, you should also change the Format property to display the results you want (for example, *****).

Painter: Password option.

Required

Whether the column is required. Values are:

• Yes — It is required.

• No — It is not required.

Painter: Required option.

SipOnFocus

Whether to display or minimize the SIP when the column receives focus. Values are:

• Yes — SIP opens automatically.

• No — SIP closes automatically.

Painter: Show SIP on Focus option.

Style

(Describe only) Returns the edit style of the column.

Painter: Style Type option.

ValidateCode

Whether the code table will be used to validate user-entered values. Values are:

• Yes — Use the code table.

• No — Do not use the code table.

Painter: Validate option, available when Use Code Table is selected.

VScrollBar

Whether a vertical scroll bar displays in the line edit. Values are:

• Yes — Display vertical scroll bars.

• No — Do not display vertical scroll bars.

Painter: Vert Scroll Bar option.