It depends, Luis, on how the output must look like
Maybe including the lineDiscount and lineTax in the select will do
Select fi.ftstamp, ;
fno, ;
ref, ;
design, ;
qtt, ;
epv, ;
etiliquido, ;
usr4 AS 'Codpautal', ;
codigo, ;
lineDiscount, ;
linetax ;
;
from fi ;
order by fi.fno ;
into cursor Linhas ;
where fi.fno = 121005551
>Hello Gregory
>
>Many thanks for your help, now the code work great.
>
>Please tell me , i need to create 2 subnode for each line of my invoice, like this
>
>Lines
> lineDiscount - to keep comercial discount on each line
> linetax - to keep tax percent and value on each line
>
>When i go to create this 2 new cursors, i must also create na INDEX for each one ?
>
>Many thanks,
>Luis Santos
Gregory