RELATE ONE SELECTION =C2=A0strangeness
John Baughman (6/9/14 3:05PM)
John Baughman (6/9/14 3:05 PM)
In the following, there is a many to one relationship between
[_Mechanics]_Appointment_Sequence & [Appointment]_Appointment_Sequence
with [_Mechanics] being the many table.
ALL RECORDS([_Mechanics])
RELATE ONE SELECTION([_Mechanics];[Appointment])
zeroCount:=0
$size:=Records in selection([Appointment])
For ($i;1;$size)
¬=A0¬=A0GOTO SELECTED RECORD([Appointment];$i)
¬=A0¬=A0$mechanicsFound:=0
¬=A0¬=A0SET QUERY DESTINATION(Into variable;$mechanicsFound)
¬=A0¬=A0QUERY([_Mechanics];[_Mechanics]_Appointment_Sequence=[Appoin
tment]_Appointment_Sequence)
¬=A0if ($mechanicsFound=0)
¬=A0¬=A0¬=A0¬=A0$zeroCount:=$zeroCount+1
¬=A0end if
End for
At the end of this loop zeroCount is 2. How is this possible?
John
John Baughman
Kailua, Hawaii
(808) 262-0328
johnbdh@...
Reply to this message
Summary created 6/10/14 at 8:02AM by Intellex Corporation
Comments welcome at: feedback@intellexcorp.com