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.<br>
<br>Any help greatly appreciated!<br>Warren<br><br><div class="gmail_quote">On Mon, Mar 28, 2011 at 12:19 AM, Warren Kuhl <span dir="ltr"><<a href="mailto:warrenkuhl@gmail.com">warrenkuhl@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">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.<br>
<br>Here is my code in Runtime Revolution....<br><br>put VDataBase_SqlSelect(mDatabase,"SELECT term1 FROM MyTable where Keyword1 = '" & tphrase & "'") into curs <br>put VCursor_FieldValue( curs, 1 ) into tTerms<br>
put empty into curs<br><br>Thanks for any help!<br><font color="#888888">Warren<br>
</font></blockquote></div><br>