Hi Gang!

I was asked to see why the Application sometimes acts like it gets things out of order when processing....

e.g... The Application wants to REVERSE claims sent in to 2 third party insurance claims departments.

Sometimes it acts like it reverses the Primary, but not the Secondary. Sometimes the Secondary and not the Primary.


I was checking the code and came across this statement....

IF (Thisform.m_seek(lcFullerRx,"rx_claim","fullerx",1)) AND (rx_claim.statuscode = 2) AND (rx_claim.n_103_a3 = "B1")

Now, the m_seek does a seek, looking in the rx_claim table for a claim.
Notice that the the second item is also from rx_claim, and is the third item.

I was of the opinion that the processor would execute the code form left to right in the statement.... so the seek would FIND the correct rx_claim record first, THEN check to see if statuscode is 2 and n_103_a3 is 'B1".

But is this always true? Is it possible that it can sometimes do the 2nd or 3rd item first, THEN do the seek????

I just have a bad feeling about this, since the 2nd and 3rd item DEPEND upon the 1st ITEM......

If so, I can rewrite the code to execute each thing in order......

Thanks!
Tommy