See setNull <http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setNull(int,%20int)> in the jdbc javadoc
> On 31. jan. 2015, at 18.58, Bob M <[email protected]> wrote: > > 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.
