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. 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:41 PM > Steve: > > No, actually there shouldn't be any nulls in the table. > When an autopsy is > done they take all these tissue samples and have to report > a value for each one > to prove they did their job (nice to know when an autopsy > is done there's > about 740 different tests they have to do). This client > has other tables with > hundreds of columns, but not this big. They don't have > many edit forms -- > they are used to bringing the table up in the browser, > inserting a row and then > typing numbers all the way across. That's why they > want it this way. > > BTW: I found the limit. I can get 583 columns to define, > but adding a > single extra causes the problems. > > Karen > > > > I’m gonna’ take a SWAG on one little thing – for > now anyway – but I bet > > there a LOT of NULL column values in that table. > > > > I recall your using “client INSISTS”, but LOTS OF > NULLS is a common > > indicator for poor data modeling. > > > > Steve in Memphis > > > > > >
