Structure table :
- mydate default 'now'
- mycode varchar(7) default ' '
- myqty integer default 0
- mytime time default 'now'
- Myflag varchar(1) default '0'
- mystatus varchar(1) default '0'

Insert into myss(mydate,mycode,myqty) values ('04/06/2011','TD00212',3);


: for 7 record , field mytime, myflag and mystatus is Null...


Thanks
Sent from my BlackBerry� smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

-----Original Message-----
From: Ann Harrison <aharrison@...>
Sender: firebird-support@yahoogroups.com
Date: Tue, 24 May 2011 12:21:32
To: <firebird-support@yahoogroups.com>
Reply-To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Record null on default '0'

On Tue, May 24, 2011 at 12:15 PM, <allies_xposs@...> wrote:
>
> I already have that record and default '0' before storing data..
>
> Actual data,
> Abnornal recard just 7 record from 7329 record at 6 and 7 may 2011. After that and untill now data normal (default '0').
>

OK, then it's time for some serious detective work. How many places in
your code insert records into that table? How many do updates? Do you
have triggers on the table? Is there anything unusual about the records
with nulls, other than that they have nulls? Is there anything you can do
to reproduce the creation of null values in the default 0 field?


Good luck,

Ann



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