Alan,

In most of my applications default values should be visible at the clients side. For example if I add an orderline I want to see the quantity default to 1. It does not make sence to do this at the database level since when adding the record it is not saved at the database yet, so no default value shows up. It also avoids doing a requery to see the default value.

In general the default value should be determined by the client application, not by the database as those default values are mostly application specific and not domain specific.

Walter,

>Walter,
>
>If you can set default values at the database level (either local or remote), why do you suggest doing it on the client?
>
>I just like to "set it and forget it" (default values, that is) at the database level so my client never has to worry about this. Just my preference.
>
>Al
>
>
>>>Your database back-end should be assigning default values - not your client.
>>
>>Yeah right and I'm the pope.
>>This is the greateses nonsense I've ever heard.
>>
>>Of course in other environments (like .NEt) it might make sense, but not in an environment where you've got a local database.
>>
>>Walter,
>>
>>
>>