db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre Tjeldvoll <Dyre.Tjeldv...@oracle.com>
Subject Re: Inserting and deleting records
Date Sat, 31 Jan 2015 19:03:34 GMT
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 <rgmatthews@orcon.net.nz> 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.


Mime
View raw message