Thank's Bryan for that information............... I have sorted it out now
The profit field is a dec(5,2) field and so I am using DEFAULT 999.99 Then when I wish to update the latest record with the profit I use a WHERE profit=999.99 All good :) Thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Initializing-a-new-record-where-field-is-NULL-by-default-tp143732p143738.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
