Subject | Re: [firebird-support] database growing too much after bulk |
---|---|
Author | masotti |
Post date | 2008-11-06T16:30:10Z |
Hi Sergio,
then StockNOTAS.Clear
else StockNOTAS.asString := DBF_StockNOTA.AsString;
Try this small change in your code.
HTH.
Ciao.
Mimmo.
> I first removed the default '' from the blob field "notas" domain, and importedNULL Blob is different from empty string Blob.
> the DBF, and again, the DB grew to 179,00 kb, but then I commented out the line
> in my progran which assigns the blob field, and imported again, and the DB now
> is 12MB, so the problem was in the blob field.
>
>
> // ** THIS IS THE BLOB **if (DBF_StockNOTA.AsString = '') or ( DBF_StockNOTA.IsNull)
> StockNOTAS.asString := DBF_StockNOTA.AsString;
>
then StockNOTAS.Clear
else StockNOTAS.asString := DBF_StockNOTA.AsString;
Try this small change in your code.
HTH.
Ciao.
Mimmo.