RAD Studio |  |

Setting a Default Value for a Field
See Also
Collapse All

You can specify how a default value for a field in a client dataset or a BDE-enabled dataset should be calculated at runtime using the DefaultExpression property. 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 would be

Copy Code

    '12:00:00'

including the quotes around the literal value.

Note: If the underlying database table defines a default value for the field, the default you specify in DefaultExpression takes precedence. That is because DefaultExpression is applied when the dataset posts the record containing the field, before the edited record is applied to the database server.
See Also

Working with Field Component Methods at Runtime

Displaying

Persistent Field Components

Working with Constraints

Using Object Fields

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!