db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Re: Updating the last column in the newest record
Date Thu, 29 Jan 2015 21:10:18 GMT
Hi Alex

Trying to understand all of this.....................

the qualifier I wish to use is a combination of two fields - date and time
[time is either 0, 6, 12, or 18 meaning hours]

Does 9000 in your coding suggestion mean blank?

So am I right in thinking
1) create new record by updating /inserting ONLY 26 field values leaving
27th field {Profit/Loss} out
2) later, update latest record - just updating the profit/loss field using
modified code
UPDATE TABLE SET PROFIT_LOSS=9000 WHERE DUE_DATE = (SELECT MAX(due_date)
from TABLE)

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record-tp143710p143718.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message