problems to destroy a cursor

[Ruslan Zasukhin]

On 3/24/08 6:59 PM, "-= JB =-" <sundown at pacifier.com> wrote:

> I am using Revolution 2.9.0 and Valentina 3.5.1
> 
> In the Reference PDF is states the below concerning a cursor from a
> SQL command.
> 
> Note: When finished with a cursor, you must assign it the value nil
> to destroy it and free
> memory.
> 
> Does this mean I need to somehow nil the cursor before I destroy it
> or are they trying
> to say I need assign it a value of nil by destroying it which will
> free the memory.

I think this text is copied from some other OO ADK.
Revolution do not need nil pointers.
 
> I am able to get a cursor ref number and the following seems to
> destroy it but I am
> not able to check and see if it has been destroyed.
> 
> get VCursor_Destructor(curs)

After this call it must be destroyed.
 
TIP: use Valentina_DebugLevel(3) to force production of V4REV_Log file,
 this file may contain some info about errors in params or such.

> How can I check to see if the cursor has been destroyed and can
> it cause problems to destroy a cursor that was already destroyed.

You cannot see I think.

Aha, I am wrong. Yes while you are in DEBUG LEVEL,
    Valentina for Revolution VALIDATES all refs.
    so if you call some V4REV method with wrong CursorRef,
    you will get such error code back in code,
    and in the log file also.
     
 
> Also the reference pdf mentions another way to destroy a cursor
> is to use the following:
> 
> get Cursor_Destroy(curs)
> 
> When I use the above to destroy the cursor I get an error message
> when the
> script executes.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]