Memory Issues

[Warren Kuhl]

After further testing my application, the only way free up memory (that I
can tell) is to close my database...which is done when I close my
application.  Is there anyway to free up memory at the end of my SQLSelect?
I am doing multiple SQLSelects and the longer I work with my application,
the slower my PC runs as my Valentina DB is sucking up my memory.

Any help greatly appreciated!
Warren

On Mon, Mar 28, 2011 at 12:19 AM, Warren Kuhl <warrenkuhl at gmail.com> wrote:

> 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
>
> Thanks for any help!
> Warren
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110328/82c3f01b/attachment.htm>