>What is the exact difference between two?

>I do need to set order for SQL-Select using OLD style indexes (IDX). That was discussed recently on UT and Hugo R helped me to understand that. For these tables we're using old style IDX indexes.

I think you need to SET INDEX TO to open the .idx so it can be used for Rushmore. I can't prove that at this moment.

I'm pretty sure you don't need SET ORDER.


>
>
>
>>>

>>>SELECT Comision
>>>				lnRecno = RECNO()
>>>                SET ORDER TO com_inv IN comision
>>>
>>>                SELECT SUM(rate*SHARE/10000) AS crate WHERE inv_no+salesman = m.ccinv + m.Slsman ;
>>>                	FROM comision INTO ARRAY laArr
>>>                lcRate = EVL(laArr[1],0)		
>>>                IF SEEK(m.ccinv + m.Slsman)                	
>>>					SUM (rate*SHARE/10000) TO cRate WHILE inv_no+salesman = m.ccinv + m.Slsman
>>>				ELSE
>>>					cRate = 0
>>>				endif		
>>>                	
>>>                	IF NOT m.cRate == m.lcRate
>>>                		=MESSAGEBOX("Found a mismatch on " + m.ccinv + m.Slsman)
>>>                		_cliptext = _cliptext + "Found a mismatch on " + m.ccinv + m.Slsman + " cRate = " + ;
>>>                		         	TRANSFORM(m.cRate)  + " laArr[1]= " + TRANSFORM(m.lcRate)
>>>                	ENDIF

>>>
>>>The two reported mismtach cases are wrong, since in first case the invoice is for different person and in second it doesn't exist. I just re-indexed the table on inv_no + salesman and the problem persists.
>>>
>>>Do you know, what I'm doing wrong?
>>>
>>>Thanks again.