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.
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
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.