How do I set Sweep Interval in Firebird DB using IB components?
lazarus / 16-Databases

----------------------------------------------------------------------
RedOctober · 2018-01-11 03:04

I can see MON$SWEEP_INTERVAL in the MON$DATABASE system table, and I
can display that to my user.  Now I need to allow my user to change
the Sweep Interval.  My Windows app uses TFBAmin and TIBQuery etc. but
if I do an:

UPDATE MON$DATABASE SET MON$SWEEP_INTERVAL = 0;

I get an error message saying operation not supported.  I get this
same error message using FlameRobin, if I run the above SQL
statement.  However, FlameRobin has a "Properties" page that allows
the user to set the Sweep Interval.

How can I give my app the same functionality as FlameRobin?  I want to
set the Sweep Interval, the Read Only, the Forced Writes and the
Reserve Space settings for Firebird databases 2.5 and up. I don't
think I can use "gfix" because my app connects to remote servers by IP
address and port.

----------------------------------------------------------------------
taazz · 2018-01-11 16:10

there is a component suite  that you can use for firebird (IBX : http:
//forum.lazarus.freepascal.org/index.php/topic,35052.msg231107.html#ms
g231107). It has the control TIBConfigService which has the method
setsweepinterval. You can use it as is or you can copy only the code
you are interested in. You can find it in the online package manager
as IBX