In the help for Advantage Database Server I found this information:
"ADM memo files keep a "free block" list in its header.
This list indicates which blocks within the file have been freed.
An abandoned block will be reused before adding a new block to the bottom of
the ADM file."
But the mechanism of using free blocks in a ADM file doesn''t work when I
try to use any triggers in a table.
So the ADM file become bigger and bigger when I use UPDATE sql-query for the
But if I don''t use any triggers, it works perfectly.
Could you tell me, may be I did something wrong?
I will be very thankful for your answer.
Subject: triggers problem with ADM memo
Date: Thu, 31 Jul 2008 11:49:30 +0400
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
X-Trace: 31 Jul 2008 01:42:36 -0700, 184.108.40.206
Xref: solutions.advantagedatabase.com Advantage.Trigger:404
Article PK: 1136466