>my typo
>

>* try 3 : can to go in error if (cTrans_fk ,iSequence_Number) is not unique and is it slow too ?
>SELECT X.cTrans_pk cTrans_fk;
>  , (SELECT TI.cInsurances_fk FROM Trans_Insurances TI ;
>         WHERE TI.cTrans_fk = X.cTrans_pk AND TI.iSequence_Number = X.iSequence_Number);
>    cInsurances_fk;
>    FROM (select curTemp.cTrans_pk , max(T.iSequence_Number) iSequence_Number;
>    	from curTemp JOIN Trans_Insurances T ON curTemp.cTrans_pk = T.cTrans_fk ;
>	    GROUP BY 1) X ;
>into cursor curTemp1
>

>
>You can uses 2, but it is out of SQL standard,
>5 is not readable,
>4 is better.
>
>UPDATE: ok for the 2. On a more smart backend uses the 1th.

Thanks again. We haven't started testing my new changes, so this may wait a little bit.

BTW, I sent you a PM.