From RAD Studio API Documentation
Jump to: navigation, search


property DefaultExpression: string read FDefaultExpression write FDefaultExpression;


__property System::UnicodeString DefaultExpression = {read=FDefaultExpression, write=FDefaultExpression};


Type Visibility Source Unit Parent
property published
Data.DB TField


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

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


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.

See Also