>I have a SELECT SQL statement like this:
>
>SELECT Table1.codclie, Table1.Date Table2.Name FROM Table1, Table2;
>WHERE Table1.codclie = Table2.codclie ORDER BY Table1.zone, Table1.codclie;
>INTO CURSOR MyCursor
>
>Table1.codclie Caracter 7
>Table2.codclie Caracter 7
>
>And I use the result cursor to print a report. The problem is that the SELECT, sometimes gets, for example, 10 records. And later if i intend to print the report again, the SELECT gets 11 records.
>I mean, there is one o more record missing that should be selected.
>
>Does anybody know what the SELECT statement takes on count at the moment of the selection?
>
>Does the indexes have something to do with this???
>
>Please, help me. This seems like a Nightmare to me.

Does the SET EXACT setting change somewhere between?
Are you using exactly the same piece of code when reporting the second time?

Someone could be adding records between the first report and the second report.