--- In IBObjects@y..., "emgfyah2002" <edison@w...> wrote:

> Dear Norman
> Thank you very much. It works. As a matter of fact, the 'Required'
> was grayed, but after I clear it, no more problems.

I'm surprised. Default values are assigned by the server only if no value is specify by the client. With normal setup, the client sends "null", so the field remains null.
Maybe your setup avoids errors, but I dubt that puts the default value into your database.
If you want the table have the default value defined, you have to set two properties:
IB_Query.GetServerDefault=True
and, optional but very useful if you use a lot of domains
IB_Connection.FieldEntryTypes=[fetDomainName]
This will bring defaults from server to your client app and back when posted. In addition, user has a visual clue of what is the field (default) value
Regards
Marco Menardi