🚀 go-pugleaf

Here is a way:

Create a Connection class (Connection.cpp) with a TADOQuery and a method like (not tested):

Connection :: Connection () 
{
   //set your connection string here.
   ADOQuery1->ConnectioString = ...
   //Or you can set the connection string in de object inspector
}

TADOQuery *Connection :: open(String stmtSQL)
{
   try {
      ADOQuery1->Close();
      ADOQuery1->SQL->Clear();
      ADOQuery->SQL->Add(stmtSQL);
      ADOQuery1->Open();
   } catch (Exception &e) {
      ShowMessage (e.Message);
   }
   return ADOQuery1;
}

you can call this class by:
//include header
#include "Connection.h"


TADOQuery *qry = new TADOQuery(Application);
Connection *con = new Connection();

String SQL = "SELECT * FROM myTable"
qry = con->open(SQL);
//do something with the query;


//delete adoquery en connection
delete qry;
delete con;

Good luck.



"Sara T." <sarana@thaiquest.com> wrote:
>I'm using an simple ADOQuery with:
>AdoQuery1.Close;
>AdoQuery1.Sql.Clear;
>AdoQuery1.SQL.Add('select * from myTable');
>AdoQuery1.Open;
>
>Every call I lose memory.
>
>I found the same question in Google but nobody answers.
>
>Sara T.
>
>"Pieter" <Pieter@nomail.com> wrote in message 
>news:42e62634$1@newsgroups.borland.com...
>>
>> It would be easier to tell something if you post some code.
>> Pieter
>>
>> "Sara T." <sarana@thaiquest.com> wrote:
>>>Does anybody find this?
>>>
>>>I have something to create and destroy this object (TADOQuery) a lot of
>>>times, I found TADOQuery does not release the memory and eats memory until
>>>the machine becomes out of memory.
>>>
>>>I thought the several people found this problem (I search in the google) 
>>>but
>>>nobody answer.
>>>
>>>Again, it anybody finds the solutions, lindy post it.
>>>
>>>Sara T.
>>>
>>>
>> 
>
>