On Mon, 30 Oct 2006 08:13:39 +0100 Peter.Colpaert@xxxxxxxxx wrote:
I'd rather not use the FIDS, but rely on an SQL count(*) to give me the current record count.
I prefer to use the old-style file I/O methods. Is it written somewhere that trigger programs can't count on the FIDS?
AFAIK, the trigger program is called for each insert, and the next insert has to wait until the previous call to the trigger program is finished.
That's the way that makes sense to me, but I wasn't sure.
In this case, you only need to delete the oldest record to keep your number of records under the limit.
That's what I'll try. Thanks.