--- In firebird-support@yahoogroups.com, "Gary Benade" <hobbit@l...>
wrote:

> Alan
> Why not just let interbase/firebird handle these seconday files
> automatically the way it was designed to.
> ALTER DATABASE ADD FILE 'file2.gdb' STARTING AT PAGE 10001 LENGTH

10000

> ADD FILE 'file3.gdb' STARTING AT PAGE 20001 LENGTH 10000
> ADD FILE 'file4.gdb'
>
> Is there a special reason you need to do this manually?
>
> regards
> Gary

When the file size exceed 4G, firebird will stop writing to it
and firebird doesn't auto gend the secundary file, we need to check
the current file size and when it exceed a specific number, alter it.

In fact, I hope to do is in the program I can receive the event
that firebird told me the file size is not enough, at this time, add
one more secundary file, at next time when I receive that event, add
another one secundary file ..etc, and I no need to check every time
and no need to add several numbers of database at the beginning.

The optimized method is something like auto gend(but I think it
can't realize)