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