Memory Issues

[Ruslan Zasukhin]

On 3/28/11 8:19 AM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:

Hi Warren,

> Is there anything I have to do to a empty my memory when doing select
> statements with Valentina?  It seems like each of my select statements are
> increasing the storage in my memory when I run my application.   Eventually
> the software bogs down my pc.  When I comment out the select statements,
> this doesn't happen.  I was under the impression that as long as I empty my
> cursor when I don't need it anymore, this should take care of the problem.
> 
> Here is my code in Runtime Revolution....
> 
> put VDataBase_SqlSelect(mDatabase,"SELECT term1 FROM MyTable where Keyword1
> = '" & tphrase & "'") into curs
> put  VCursor_FieldValue( curs, 1 ) into tTerms


> put empty into curs
^^^^^^^^^^^^^^^^^
    I think this is wrong line.



Curs  is CursorRef.

In V4REV architecture, you create objects using V4REV funcs,
And you must destroy them using V4REV funcs.

You should call something as

    VCursor_Destructor( curs )



-- 
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]