Sifuddin

If that code runs OK under VFP7 there should not be a problem with VFP9.

Gaylen


>Where to put this "behavior", in start of each form. And, please look the following syntax, is there any changes for VFP9.
>
>

>SELECT dSiMain.*, dSisUb.icode, dSisUb.Quantity, dSisUb.Rate,;
>                  dPCode.pname, dIcode.full_desc, dIcode.maincat, dIcode.category,dIcode.subcat ;
>                  FROM dSiMain;
>                  RIGHT JOIN dSisUb ON dSiMain.SiNo == dSisUb.SiNo;
>                  LEFT JOIN dPCode ON dSiMain.pcode == dPCode.pcode;
>                  LEFT JOIN dIcode ON dSisUb.icode  == dIcode.icode;
>                  WHERE BETWEEN(dSiMain.DATE, dt1, dt2) ;
>                  INTO CURSOR tempsale ORDER BY maincat
>
>