Re: Updating several consecutive fields in a record

2016-07-06 Thread Bob M
Thank you Bryan Simple and elegant :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385p146387.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Updating several consecutive fields in a record

2016-07-06 Thread Bryan Pendleton
psUpdate = conn.prepareStatement("UPDATE SET PROFIT_LOSS = ? WHERE Now, I wish to update seven consecutive fields in the latest derby record You can list multiple columns in the UPDATE statement: UPDATE my-table SET col-1=?, col-2=?, col-3=? WHERE ... And then use multiple

Updating several consecutive fields in a record

2016-07-06 Thread Bob M
en consecutive fields in the latest derby record What is the best way to recode the above section of code? Many thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385.html Sent from the Apache Derby Users mailing list archive at Nabble.com.