<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 3/29/2011 7:06 AM, Warren Kuhl wrote:
<blockquote
cite="mid:AANLkTimV+mUhxW6xR0SCitDRj9Q11A5sXDA=S+tQ8S3f@mail.gmail.com"
type="cite">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 moz-do-not-send="true"
href="mailto:warrenkuhl@gmail.com">warrenkuhl@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
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>
</blockquote>
<br>
curs is just a handle which keep reference to vCursor. In other
words it is just a some integer (address of vCursor object)<br>
put empty into curs -- Just forget (loss) a handle - nothing
happened to vCursor<br>
<br>
Instead you should call:<br>
put VCursor_Destructor( curs ) into curs<br>
<br>
See V4REV examples and docs for details.<br>
<br>
<pre class="moz-signature" cols="72">--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a class="moz-txt-link-freetext" href="http://www.valentina-db.com">http://www.valentina-db.com</a></pre>
</body>
</html>