🚀 go-pugleaf

I found the solution:

TADOConnecction.KeepConnection=false

It seem that wit Keeping Connection On all recources of on database
transaction are not released.

Why ???


"Andreas Weichert" <weichert@trios.de> schrieb im Newsbeitrag
news:3f9d4d4f$2@newsgroups.borland.com...
> Hello !
>
> I use BC-Builder 5.0 and with ADO
> I store large string in an memo filed in an Access-Database.
> I have a leak in every update of ca. twice lenth of the string length.
>
> Here is my exaample code:
>
>     for(int j=0; j<9; j++)
>     {
>         TADODataSet *P = new TADODataSet(NULL);
>         P->Connection=theDataBase.itsCon;
>         P->CommandType = cmdText;
>         P->CommandText = "select * from tblData where IDData='xxxx'";
>         P->Open();
>         P->Edit();
>
>         for(int i=0;i<P->FieldCount;i++)
>         {
>             TString
FieldName=(P->FieldList->Fields[i]->FieldName).c_str();
>             if(FieldName=="Data")
>                 P->FieldList->Fields[i]->AsString=TString(100000,
> 'x').c_str();              // Line   A
>                                             // 100.000 Byte
>         }
>         P->UpdateBatch(arAll);                // Line B
>         P->Close();
>         delete P;
>     }
>     MessageDlg("xxxxx", mtWarning, TMsgDlgButtons() << mbOK, 0);
>
>     ==>>>>   Total loss of  ca. 2 MB;
>
> If I comment Line A   or   B  I have no memory loss
>
> What goes wrong ????????
>
>
>
> Andreas
>
>
>
>
>
>
>