Hi Dyre I am still not grasping this.................
I have psInsert = conn.prepareStatement("INSERT INTO TABLE VALUES(?, ?......, ?) [27 of them] psInsert.setString(1, date); ................ psInsert.setString(25, class); psInsert.setString(26, Trade_ID); but I am unclear what to put for the final line referring to Profit and where I wish to set it to NULL initially which is the default Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Initializing-a-new-record-where-field-is-NULL-by-default-tp143732p143735.html Sent from the Apache Derby Users mailing list archive at Nabble.com.