problem in sql

oscarea

Dear friends, I have a problem with Navision financials 2.6 SQL, I execute a listing of products and of each product I consent to the table 32 of mov. of products to take out certain information (with a repeat_____until, reset in each product of the chart 32), the first time it leaves me well, but I throw it without leaving the program again and they don't leave the same data, I have been able to see that making the repeat ____ until becomes crazy and he/she begins to repeat a product. It is as if the repeat to execution half lost the filter.
Somebody can help me.

<img border="0" title="" alt="" src="images/smiles/icon_sad.gif" />

oscarea

THIS IS THE CODE:

RecProd.RESET
IF RecProd.FIND(‘-&#8216 <img border="0" title="" alt="" src="images/smiles/icon_wink.gif" /> THEN REPEAT
MP.RESET;
MP.SETCURRENTKEY("Tipo movimiento","Subtipo movimiento","Nº producto","Fecha registro");
MP.SETRANGE("Nº producto",RecProd."Nº producto");
MP.SETRANGE("Tipo movimiento",MP."Tipo movimiento"::Compra);
MP.SETRANGE("Cód. procedencia mov.",Proveedor);
MP.SETFILTER("Fecha registro",'>=%1&<=%2',Rec."Fecha ini analisis",Rec."Fecha fin analisis");
IF MP.FIND ('-') THEN REPEAT
T1 := T1 + MP.Cantidad*MP."Precio neto comercial";
T2 := T2 + MP.Cantidad*MP."Precio neto final";
T3 := T3 + MP.Cantidad*MP.PVP;
UNTIL MP.NEXT=0;

UNTIL RecProd.NEXT=0;

THANKS.

oscarea

thanks, but the problem continues existing, I have removed the range that not this in the key and the first one makes it to me well and it can be that the second also, but the third report already makes it to me bad, I have looked at the information that he/she goes taking out and a moment that loses the filter of the product arrives and you doesn't come out but rather it continues, it finishes that product and then he/she makes the other ones but with the filter of the previous one.