>>I have a simple problem I don't understand. Create a cursor with select sql and run a report form with fields from the cursor. The cursor contains a subset of 10 records and is positioned on the first record in the cursor. The report form is printing 10 copies of the last record in the cursor. Why? The cursor is not written to disk but is open in the currently selected work area.
>
>Hi Eric.
>
>Two things to check. Ensure that the report fields don't point to another table or cursor. Also, make sure the cursor is the currently select one by doing a "select".
The workarea is properly selected, else he would get much more than the subset of ten records. The report fields probably use the other table's alias, not the cursor alias (or even better, no alias at all, so it can run on any other cursor with the sufficiently equal structure).