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.
