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.
