Subject | Re: [firebird-support] SQL - Default Value ? |
---|---|
Author | Lucas Franzen |
Post date | 2005-01-03T15:13:13Z |
pierre.yager@... schrieb:
The trick is to omit the field from the insert list.
Defaults are only applied if the field is NOT part of the insert statement.
You might also want to take a look at the system tables (RDB$FIELDS or
RDB$RELATION_FIELDS, the field is RDB$DEFAULT_SOURCE).
Luc.
> Hi all,There's no secail keyword.
>
> Happy new year 2005 !
>
> I would like to know if there is a special keyword to force a field to be
> initialized to its default value in an insert command.
The trick is to omit the field from the insert list.
Defaults are only applied if the field is NOT part of the insert statement.
You might also want to take a look at the system tables (RDB$FIELDS or
RDB$RELATION_FIELDS, the field is RDB$DEFAULT_SOURCE).
Luc.