Karen, Could be the difference between the way we count the space occupied by TEXT fields. In the RBase ".RB1" file the column section contains a field that contains the displacement from the beginning of the row for each column. Thus while RBase might report a character size as 1 say in column 1 (displacement 0) the next field would be at displacement 3. Note displacement begins counting at position 0.
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, 5:10 PM > When I do your select I get 3681. Not sure why it's > less than what we're > manually calculating .... > > Karen > > > > 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')
