thanks for the info.

i look forward to converting my app and really appreciate forums
like to when i get stumped.

regards
kelly

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> 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
>