Subject Re: [firebird-support] fb table limit question
Author Helen Borrie
At 09:39 AM 2/03/2006, you wrote:
> hi--
>
> i am just beginning a conversion from BDE to FB / IBO.
>
> one of my main concerns is the number of fields per record/row in FB.
>
> the BDE is limited to 255 and that is was too low for my app.
>
> i have spent hours looking on the web for a maximum column per row count in
> FB 1.5 and.or 2 and just can't seem to find one.
>
> is there a limit? is it greater then 255?

There is not a "column count limit". The maximum width of a row is
64 Kb, minus a few bytes. Add up the byte count for the declared
size of each column, counting 8 bytes for each BLOB or ARRAY type
column, and adding 2 bytes for each VARCHAR column. Integers,
floats, date, time are 4 bytes; BigInt, double precision, timestamp
are 8; numeric and decimal, 4 (if precision < 10) or 8 otherwise.

> and one other thing...i also have an ISAPI DLL created with Intraweb. I'm
> assuming that FB / IBO work just fine with IW, correct?

Isapi DLLs work fine with an IBO back-end. The Community site
(community.ibobjects.com) and the IBO FAQ are both Isapi
dlls. Whether there are any problems specific to Intraweb, I don't
know. The Community site was built with Indy; the FAQ app uses a
regular Delphi web app.

>(hmmm..i seem to be having a hard time posting this using Outlook Express
>NewsGroups...so, i emailed it to yahoogroups.com, is that usual?)

Yes. This is an email list, not a newsgroup. You *can* use a
newsgroup interface, as this list is mirrored at
news.atkin.com. Advice about using OE is off-topic here, of course,
but quite a few of us use Xananews, a news client written with Delphi
and Indy. If you're interested, Google for it.

Helen