Context within a process

vinsnash

I'm trying to follow the context rules but am having difficulty.

I have a process that creates an instance of an object in the 1st rule:

ENTER NEW OBJA USING MAIN

The main form is displayed, data entered, and the 'CREATE' button pressed. The instance is created correctly.

Then in a 2nd rule in the process I want to use an attribute of the instance of OBJA just created to find an instance of another object

FIND OBJB WHERE (OBJA.abc = OBJB.abc)

The instance of OBJA has the correct 'abc' attribute and I know there is an OBJB with a matching 'abc' value.

The FIND is failing on me. I need to create a transaction record of the of the creation of the new OBJA instance and I need to include attributes of the matching OBJB in that transaction record.

The User Guide tells me that the 'CREATE' places the new instance in context but I'm finding that is not quite the case. At least within the process. This is a 'bean counter' non negotiable must. I need help with this one.

Thanks

Vins Nash

rocketman

Vins - no time to test is the post correct? FIND OBJB WHERE (OBJA.abc = OBJB.abc) should be FIND OBJB WHERE (OBJB.abc = OBJA.abc)

and if that doesn't work try FIND OBJB WHERE (OBJB.abc = ThisOBJA.abc)

vinsnash

You may have it there. Too close to the forest to see the trees maybe. I'll have to wait until tomorrow to check it out. Server is down for maintenance so I can't telecommute.

Thanks for the heads up.

Vins

vinsnash

I've tried the suggestions to no avail. Actually it turns out everything I need for the transaction record is in the member record so I changed the process rule as shown below. After entering the new NSCPers instance and clicking the create button the "Sending Data" progress bar appears and then I'm returned to a previous query result display. tThe CREATE does not occur and there is no indication in the log of an attempt to execute it. The NSCPers instance is created exactly as it should be with all the correct values in attributes. The "Pending" instance will kill two birds with one stone. It will give the account what's demanded for history and provides an exportable file to feed an ID card printing application. So the question is how do I make a rule execute after pressing that "Create" button on the NSCPers main screen.

IF EXISTS NSCPers then ENTER NEW NSCPers USING Main

CREATE Pending WITH
Pending.MemberType=NSCPers.MemberType,
Pending.Type=NSCPers.MemberStatus,
Pending.SocialSecurityNumber=NSCPers.SocialSecurityNumber,
Pending.LastFour=CHARS_FROM_RIGHT(NSCPers.SocialSecurityNumber,4),
Pending.UnitCode=NSCPers.UnitCode,
Pending.Amount=NSCPers.AmountPaid,
Pending.Date=CURRENT_DATE,
Pending.LastName=NSCPers.LastName,
Pending.FirstName=NSCPers.FirstName,
Pending.BirthDate=NSCPers.BirthDate,
Pending.ExpireDate=NSCPers.ExpireDate,
Pending.Rank=NSCPers.Rank,
Pending.Paid = 'N',
Pending.Type='P'

ACDC

have you tried using (OBJB.abc = ThatOBJA.abc)