SELECT LinhaFac.* FROM LinhaFac ; JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc; WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC"; INTO CURSOR TmpLinFacXdon´t work , because TmpLinFacX is empty .
Select TmpNCOri BROWSE SELECT LinhaFac.* FROM LinhaFac ; JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc; WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC"; INTO CURSOR TmpLinFacXWork Ok , TmpLinFacX have records .