RELATE ONE SELECTION =A0strangenessbob.miller at parker.com (6/10/14 11:16AM)
bob.miller at parker.com (6/10/14 11:16 AM)
This is indeed strange. ?If you don't use SET QUERY DESTINATION, do
get a different result?
If not, you can grab the unique ID of the [Appointment] record that
not have a corresponding [_Mechanics] record and examine it - with
tools, can you query and find record and, possibly the (should have
related) [_Mechanics] record?
color><param>00000,0000,DDEE/param>AAlternatively, you could set a
TRACE inside the if($mechanicsFound=0)
/color>cclause and inspect the [Appointment] record to get the unique
thereof and use that to start your analysis.
Perhaps you have a bad index...??
RE> In the following, there is a many to one relationship between
[_Mechanics]_Appointment_Sequence & [Appointment]_Appointment_Sequence
with [_Mechanics] being the many table.
RELATE ONE SELECTION([_Mechanics];[Appointment])
$size:=Records in selection([Appointment])
?=A0GOTO SELECTED RECORD([Appointment];$i)
?=A0SET QUERY DESTINATION(Into variable;$mechanicsFound)
At the end of this loop zeroCount is 2. How is this possible?
Bob Miller, IT Manager
Chomerics, a division of Parker Hannifin Corporation ? phone
? mobile 781-316-4864
Reply to this message
Summary created 6/10/14 at 1:12PM by Intellex Corporation
Comments welcome at: email@example.com