Subject | Re: Avoiding Null value and having basic default values |
---|---|
Author | Namit Nathwani |
Post date | 2004-06-17T06:59:51Z |
Hi Martijn
At 08:09 pm 16/06/2004, you wrote:
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
[Non-text portions of this message have been removed]
At 08:09 pm 16/06/2004, you wrote:
>Well, a DEFAULT clause is only honored if you don't specifyOkay, thanks for your help.
>the column in the INSERT INTO clause.
>
>So, if it does get inserted, but with a value of NULL, then
>the only thing you can do is writing triggers.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
[Non-text portions of this message have been removed]