>There have been times when I have been tempted to use the same name as a previous cursor. I don't like using q1, q2, etc. because they have no meaning. After trying to give meaningful names to all my queries, there are times when its just as easy to use the same name as a previous query.
>
>What are your feelings about that?
I agree with Sergey. I used several successive SELECT - SQL commands (for reporting purposes), re-using the same cursor name, and didn't have serious problems. However, debugging is made more difficult, and I don't use this approach any more, for new reports.
Hilmar.
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)