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.