>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
