Updating Object C with value from Object A

vinsnash

I've use 'FIND OBJ_A (WHERE OBJ_A.DATE = Current_Date)

CREATE OBJ_B FOR EACH OBJ_A WITH .....

I want to update instances of OBJ_C with a value from an attribute of OBJ_A instances that match a criteria. OBJ_C exists and the instances of OBJ_A need verification prior to updating OBJ_C.

Example:

FIND OBJ_A WHERE (OBJ_A.DATE = Current_Date)

FIND OBJ_C FOR EACH OBJ_A

OBJ_C.Code = OBJ_A.Code

Evidently the 'FOR EACH' syntax doesn't work with FIND.

Is there a function/action of some sort that would be like

FIND .... FOR EACH?

Happy New Year All!

Vins Nash

tford

You can search the User Guide for "IN BATCHES OF".

In your case, it looks like you want IN BATCHES OF 1.

tford

Also your earlier thread at

https://forum.awareim.com/d/4226>

vinsnash

I'm not sure I made myself clear on this. Is the following correct?

FIND ObjectA WHERE (ObjectA.Date=Current_Date AND ObjectA_Code = LoggedInRegularUser.Code) IN BATCHES OF 1

FIND ObjectB WHERE ObjectB.Key = ObjectA.Key

ObjectB.Amount = ObjectA.Amount
ObjectB.Date = Current_Date
ObjectA.Processed = 'Y'

ObjectA will be a temporary, imported form an external file, and validated by a process outside the AwareIM application. I would like to use something like an IF EXISTS .... THEN syntax to validate the key match on the second FIND but that doesn't clear the syntax check.

tford

Did you every try support's suggestion to break it into 2 processes in their June 16th post to the other forum post?

vinsnash

After a lot of trial and error I solved the problem. What the User Guide does not make very clear is that if you follow a FIND with updates it is finding all instances of OBJA that meet the criteria and updating before executing ProcessB at which point ProcessB only has the last instance of OBJA to act on:

FIND OBJA WHERE OBJA.A = '1'
OBJA.B = 'C'
OBJA.C = 'D'
ProcessB

ProcessB
FIND OBJB WHERE OBJB.A = '1'
OBJB.B='C'
OBJB.C='D'

If all the updates are moved to ProcessB it works because ProcessA will execute ProcessB for every instance of OBJA that meets the criteria.

FIND OBJA WHERE OBJA.A = '1'
ProcessB

ProcessB
FIND OBJB WHERE OBJB.A = '1'
OBJB.B='C'
OBJB.C='D'
OBJA.B = 'C'
OBJA.C = 'D'

I think an "AwareIM for Dummies" is needed.

Happy New Year Everybody!

Vins Nash