Default Values upon database insert

Hi

I have searched previous topics and found no past post relating to this.

I created a couple of custom numeric fields for my join page using the field builder. The fields are optional and the 'default value' on the advanced tab, of the field properties, is set to zero i.e. 0.

Upon trying to create a new member via the join page, I get the following message, should I leave the new numeric fields blank: Database Query Error.

The debug email that is sent to my bug email address reveals the issue to be a problem upon insert to the database because of these new fields. The Mysql error states that "Column 'NumberOfApps' cannot be null". True enough as 'NumberOfApps' is a numeric field, however I kind of assumed that the default value would kick in and replace my numeric field that was left blank and so I would not be left with a null value situation.

Any ideas what I am doing wrong? Have I misunderstood or overlooked anything?

Cheers

Paul  

go to phpMyAdmin > yourcustomtable > NumberOfApps and change null to not null  ..... 
.

Hi

Thank you for your reply, this I am sure that will work (even though I have not tried it yet) .....

I do not wish to sound funny, but should I have already have known how to do this? Surely this is a work around... Should I report this to Boonex as something they should advise users to do when creating fields of this type? Important, will it be of future use? I am probably misunderstanding the situation in some way. Thanks.

Cheers

Paul