Re: [firebird-support] Record null on default '0'

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@ibphoenix.com>
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@yahoo.com> 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]

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/