@Ann Harisson

Special this table : without trigger and store procedure.

Update : special this record ( null but have default '0'), I can not update to change to be '1' because I'm not detect that record ( select ... From table where myfield = '0' )

This table is transaction table, unlimited how many insert..
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);

3 record abnormal from 3201 normal record at May 06 1011,
And 4 abnormal record from 4128 normal record at may 07 2011.

Until now I'm checked the table its normal again.


Thanks.
Regard
Allies Xposs
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]