TField.DefaultExpression Property

Specifies an SQL expression that is assigned to the field if the user does not provide a value.

Pascal

property DefaultExpression: string;

C++

__property AnsiString DefaultExpression;

Description

Set DefaultExpression to provide a default value for a field. DefaultExpression can be any valid SQL value expression that does not refer to field values. If the expression contains literals other than numeric values, they must appear in quotes. For example, a default value of noon for a time field is

Copy Code

'12:00:00'

including the quotes around the literal value.

Note: If you supply a value for DefaultExpression, this value takes precedence over any default values for the field implemented on the database server. This is because DefaultExpression is applied to the field in your application before any edits are sent to the server.