UPDATE takes no acount of ORDER BY

rocketman

I needed to fix some date in my main members file. FOR EACH only seems to work with CREATE, so i set a rule in my History BO to make the necessary changes to he main file

That rule is

History.HistoryOfMember.CurrentStatus=History.Status
History.HistoryOfMember.DateStatusChanged=History.DateChanged

I then created a one off process to find, and order the history. The theory being that because it was in date order ascending, the latest history record for each member would end up being the current status of the member

FIND ALL History ORDER BY History.DateChanged
UPDATE History

DIDN'T Work. UPDATE seemed to take no account of the context order

Need a workaround fast - Membership renewal time is fast approaching. All ideas will be gratefully looked at

Running windows 1280

rocketman

Further to prev post. I tried to force an update a different way by changing a value in the History file and NOT calling UPDATE -m just letting Aware get on with things.

Again, the log viewer showed all the changes being applied (1040) followed by 1040 rule evaluations for the History file which were once again not in the requested date order

I would have thought it should have been change -rule evaluation, change - rule evaluation etc etc 1040 time

BobK

Try adding 'IN BATCHES OF 1' to your FIND.

FIND ALL History ORDER BY History.DateChanged IN BATCHES OF 1

tford

Have you tried having FIND in a process which calls another process to to the UPDATE?

rocketman

Thanks for getting back to me guys. In this instance, t was easier to clean the data manually - so I did.

Neither of your options worked and I'm just left wondering whether it is related to my post

rocketman

I finally worked it out (needed it somewhere else).Thanks for the tip Tom.

I put the find in the start process and the actual data update in another "called" process where - on the general tab I moved the appropriate In Context BO to the right column.

I've no idea why I should have to do that - why it doesn't work if it's all in one process, but I suppose the Aware guys know what they are doing. It works - that's the main thing.

Dear AwareIM Support. A brief explanation of why this is the way it is would be appreciated. It might help me understand things a little better for future development