I feel there should be an elegant way to find a maximum value for a field in a table which has been loaded in a script. For example, if I am loading sales of products, can I find the last date something was sold? I do not wish to use PEEK in case the loaded data is not in date order.
Any ideas ?
What I am trying to achieve is an incremental load, based on date.