>No matter what naming convention I may use when naming a cursor, sometimes, I'll run into a cursor which is already opened. Assuming my cursor would be named TEMPResult, wouldn't it be nice if we could define it locally such as LOCAL. Or, maybe there is already a way of doing that.
Generate a cursor name on the fly using a SYS() function. You have to change your code a bit to support this because the cursor name is saved to a variable.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer