Hi Cindy

My SQL at this time is very limited, now i do the code bellow for test, i have the data in table that match the criteria and i get a empty cursor.

I want only to view the five first documents, and i force the LcP and lcU

lcP="000001"
lcU="000005"

SELECT * ;
FROM DOCUMENTOSCABCLI A, DOCUMENTOSLINCLI B;
WHERE A.C_TIPODOC+A.C_ARMAZEM+A.C_COD_SER+A.C_NUMDOC = ;
B.C_TIPODOC+B.C_ARMAZEM+B.C_COD_SER+B.C_NUMDOC ;
AND BETWEEN(A.C_TIPODOC+A.C_ARMAZEM+A.C_COD_SER+A.C_NUMDOC, lcP, lcU) ;
INTO CURSOR DOCUMENTOS

browse


Thank's in Advance

João Batista