Thanks Dyre.................... If I choose to follow your No. 2 point to consider I set up the profit field with DEFAULT NULL There will only be one record at any point of time with the default value
When I come to inserting a new record, do I need a line of code saying psInsert.setDouble(27, ??); and if so, what do I put in ?? to get the default value there? Bob M p.s. 27 is the field number for profit -- View this message in context: http://apache-database.10148.n7.nabble.com/Inserting-and-deleting-records-tp143723p143731.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
