SELECT CREATION FROM POINT; WHERE CREATION>=ldDate AND CREATION <=ldDate2 ORDER BY 1 DESCENDING INTO CURSOR TEMPThen, when I found there was a problem, I started to display some status. So, I had something like this:
SELECT CREATION FROM POINT; WHERE CREATION>=ldDate AND CREATION <=ldDate2 ORDER BY 1 DESCENDING INTO CURSOR TEMP MyFunction() FUNCTION MyFunction Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIPAt that time, since there was a problem, the first display was showing NOT EOF and the second one, EOF. However, the _TALLY was showing 20 records. So, I knew I was not suppose to be at EOF().
SELECT CREATION FROM POINT; WHERE CREATION>=ldDate AND CREATION <=ldDate2 ORDER BY 1 DESCENDING INTO CURSOR TEMP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP GO TOP MyFunction() FUNCTION MyFunction Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIPSo, the result was now giving, NOT EOF, NOT EOF, NOT EOF and EOF.
SELECT CREATION FROM POINT; WHERE CREATION>=ldDate AND CREATION <=ldDate2 ORDER BY 1 DESCENDING INTO CURSOR TEMP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP GO TOP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIP Statut(ALIAS()+' '+IIF(EOF(),'EOF','NOT EOF()')) SKIPThat then gave me NOT EOF, NOT EOF, NOT EOF and NOT EOF. Which is what is good.
SELECT CREATION FROM POINT; WHERE CREATION>=ldDate AND CREATION <=ldDate2 ORDER BY 1 DESCENDING NOFILTER INTO CURSOR TEMPBy adding a NOFILTER, all is ok when I proceed in another function.