Colorado,

I don't think this has anything to do with your problem, but please avoid using "Name" and "Date" as column names since they are reserved words and may give you trouble at some point.

(I realize you may have been using these names just for this example.)


>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.