Thank you for your kind reply; I made a SHELL launching gfix -sweep but my problem is always there: after 255 ALTER TABLE ADD... i obtain the error 'too many version';
I purcheased the manual and I am waiting for it...probably I made some mistake in gfix...I hope the manual will help me to resolve this and others problems.-
Regards,
Luciano Bellini

----- Original Message -----
From: Ann W. Harrison
To: firebird-support@yahoogroups.com
Sent: Friday, April 13, 2007 4:31 PM
Subject: Re: [firebird-support] garbage collection


Luciano Bellini wrote:
> Hi,
> how can I cause a garbage collection without closing my program ?
> (VB and ADO - firebird 2)

With Firebird, garbage collection is a continuous activity. You don't
have to do anything. If you want to force a complete garbage collection
use gfix -sweep from the command line or through the Services API if
you're using the embedded version.

Regards,

Ann




[Non-text portions of this message have been removed]