Closing a cursor 1

[risslsu]

How do I close an SQL Server generated cursor?

I am currently trying:

CLOSE xCursorName
REALLOCATE xCursorName

Program Error when the follwing code is reached:
IF USED('xCursorName')
SELECT xCursorName
USE
ENDIF

This error lead me to believe that the cursor is not released. Any help

Thank You,
Marissa

 

[jimoo]

Your syntax looks correct if you the name of the cursor is in fact xCursorName

* Your syntax
IF USED('xCursorName')
SELECT xCursorName
USE
ENDIF

However, if xCursorName is a variable containing the name of the cursor try this:

* New syntax
IF USED('&xCursorName')
SELECT (xCursorName)
USE
ENDIF


* You may not need the & on the USE statement, but I believe it will work for sure with it.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[Mike Lewis]

Marissa,

Just to add to Jim's good advice, basically you close a SPT-gnerated cursor in exactly the same way as a normal VFP cursor.

USE IN xxx

That usuall does it, where xxx is the alias of the cursor. If you don't know if the cursor is still open, any of Jim's methods should hit the spot.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[craigsboyd]

Marissa,

A quick tip that I picked up from MikeLewis awhile back is to use:

USE IN SELECT('xCursorName')

...instead of:

IF USED('xCursorName')
SELECT xCursorName
USE
ENDIF


Slighthaze = NULL
[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]