Hi

I have the following select

SELECT LinhaFac.* FROM LinhaFac ;
  JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc;
  WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC";
  INTO CURSOR TmpLinFacX 

don´t work , because TmpLinFacX is empty .

But if i make :

Select TmpNCOri
BROWSE

SELECT LinhaFac.* FROM LinhaFac ;
  JOIN TmpNcOri ON LinhaFac.NumDoc = TmpNcOri.NumDoc;
  WHERE TmpNcOri.Selecciona AND Upper(TmpNcOri.origem) = "FACTDOC";
  INTO CURSOR TmpLinFacX 

Work Ok , TmpLinFacX have records .

Why ? What i can do ?


Thanks