> Is there a maximum number of fields per table? (I looked in Borrie's
> FB book but the limits does not mention this). If so, and its
> smallish, does it change for FB 2.x?

It depends on the used datatypes, because the max record size is ~64K.

That said, you will hit the limit pretty fast with e.g. two
VARCHAR(32000) and some additional fields. You won't hit the limit that
fast with only Integer fields.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/