Karen,
See my previous posting on this thread. But here goes:
Real 434 columns x 4 = 1736
Date 62 columns x 4 = 248
Integer 2 columns x 4 = 8
Text 1 62 columns x 4 = 248 (text occupy min 4 bytes)
Text 8 186 columns x 8 = 1488
Text 15 1 column = 16 (text occupies even number bytes
TOTAL ........ 3744 for 746 Columns
Seems within limit of 4092 bytes
Try the following command at the R>;
SELECT (SUM(SYS_LENGTH)) FROM SYS_COLUMNS WHERE SYS_TABLE_ID IN (SELECT
SYS_TABLE_ID FROM SYS_TABLES WHERE SYS_TABLE_NAME='yourtablename')
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
--- On Tue, 7/8/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Subject: [RBASE-L] - Re: Database Limits, again?
> To: "RBASE-L Mailing List" <[email protected]>
> Date: Tuesday, July 8, 2008, 4:02 PM
> I don't know how to figure out how many bytes TEXT
> columns would take.
> Here's the final count. BTW: I removed one of the
> columns so I'm at 747
>
> Real 434 columns 1736 @4
> Date 62 columns 248 @4
> Integer 2 columns 8 @4 So thru these 3
> we have 1992
> Text 1 62 columns
> Text 8 186 columns
> Text 15 1 column
>
> Anyone fill in byte sizes for me?
>
> No, I don't have a copy of V8 to play with.
>
> Karen
>
>
>
> > Karen,
> >
> > The column limit is 800 in 7.5 and 7.6....not sure
> what it was in 7.1.
> >
> > I may be all wet here, but I think the issue is the
> row size limit. You
> > say a lot of the columns are REAL, for which rbase
> reserves 4 bytes of storage.
> > Others, like Double take up 8 bytes. So it's
> possible with 748 columns
> > times X bytes - you're already close to or above
> your 4,092 bytes for the row
> > size limit. It's possible......you'd have to
> do the math. Can you try it with
> > V8?
> >
> > Dawn
> >
