Jim: I did your command, adding an =S to the length column. Again I get a total length of 3681.
Karen > Karen, Et All > > Try the following command to see how RBase has structured your file. > > SELECT SYS_COLUMN_NAME=18 as `Column Name`,SYS_LENGTH=4 AS > `Lnth`,(IFEQ(SYS_OFFSET,1,0,SYS_OFFSET))=4 AS `Dsplacm` 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, 5:14 PM > >Hmmm.... They have only 1400 columns in the database > >including this column. > > If it includes the columns in views .... > > > >But wait, actually that's not the problem. I created > >an empty database and > >the table still blew up on me. > > > >Karen > > > > > >>Karen, > >> > >>Are you perhaps running into the other limit? Total > >Number of columns in > >>the data base. That limit is something over 16,368 > >column names. I am not > >>sure if that limit applies only to table column name > >or to a combination of > >>table column name and view column names. Note!! there > >is a row in the > >>SYS_COLUMNS system view for each column in a defined > >view. > >> > >>Perhaps Razzak can chime in about the Total Column > >name limit. >
