First,thank your reply.

Alan McDonald <alan@...> 写道：

>>your application needs to omit the field >>from the insert statement to make
>>the default take effect.

>>Your applicatoin is obviously setting the field >>value to NULL which is also
>>acceptable by your definition.

Re:The truth is my app is suit for the old table struct that don't add the Filed,So I think it is omit the Field.The old app can insert record to the new table.

>>If you set the field to NOT NULL, you would >>get an exception when you tried
>>to post your data.

Re:Ok,I see.But The error happen when I update the record that Field value is null.constriant's error happened.So I think the key is I insert a record that Field omit,Why the server don't set the default to Field?

>>There is no bug here.

Re:It happened after I update Firebird from 1.03 to 1.5.3.4854,so I think it can been impacted by new server.It's just my personal judge.


Alan




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

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

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

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





SPONSORED LINKS
Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Microsoft technical support

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "firebird-support" on the web.

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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





---------------------------------
雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱
雅虎助手¨D搜索、杀毒、防骚扰

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