>>Is it possible to completely remove deleted records from a cursor? Pack gives me an error that the operation is not available for a cursor (or something like that).
>
>The usual way to handle deleted records is to SET DELETED ON. This will hide the deleted records, but not eliminate them. Since a cursor is by definition temporary, that shouldn't matter much.
>
>Did you try to reselect the data into the same cursor?
>
>
>SELECT * from MyCursor into cursor MyCursor
>
>
>Of course, you have to make sure you SET DELETED ON first.
Hilmar,
Thanks for replying. As noted, I do have Set Deleted On. The problem comes from the way I handle grid row backcolors. I have every other row set to green to help visualize different rows. I use DynamicBackColor, Mod, and RecNo() to determine which ones are white and which are green. When a record is marked "deleted", it still returns the same record number because it is still in the cursor. This has the effect of putting two green or two white lines together (the records immediately before and after the deleted record). It looks bad and confusing to the user.
Please see my reply to Nick for how I resolved my problem.
Thanks again.
Don