Hi Martijn

Thanks for responding

>1) do you want a NULL? If so, display it as NULL/empty instead of 0.0

No

>2) you can easily change the behaviour in a BEFORE INSERT or UPDATE
>trigger:
>
>if (new.mycolumn is null) then new.mycolumn = 0;

That would be tedious, specifying each and every one of the fields. Any
one stop shop <g>. I need each and every one initialized to it's
characteristic default value.




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.703 / Virus Database: 459 - Release Date: 10/06/2004


[Non-text portions of this message have been removed]