Karen, I agree with Dawn. The column limit is 800 and that limit goes back to v4.5++. Your problem is probably row size limit of 4092. The actual number of columns you can use in a table could be substantially less. Here are some limits to keep in mind. 1. No matter what the data type is all occupy a minimum of 4 bytes. 2. TEXT and NOTE data types are subject to the minimum 4 bytes but also any size larger than 4 bytes always occupy an even number of bytes. Thus say a column defined as TEXT(9) actually occupies 10 bytes. 3. DOUBLE, DATETIME, CURRENCY data types occupy 8 bytes.
Just an observation. 748 columns seem excessive. Often users try to map a previous spreadsheet implementation based on that column layout of the spreadsheet on a one for one basis into an Rbase table. I envision a whole bunch of rows with scattered columns of actual data living a lot of empty columns on each row. In mathematical terms this is a sparce matrix. You may need to better understand why they INSIST on the 748 column arrangement. Perhaps create a quick demo of a different structure that is more space and processing efficient. If they continue to insist you may have no alternative but to move to V8.0. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/8/08, Dawn Hast <[EMAIL PROTECTED]> wrote: > From: Dawn Hast <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Database Limits, again? > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 8, 2008, 3:33 PM > 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 > > -------------- Original message from [EMAIL PROTECTED]: > -------------- > > I asked this a long time ago but cannot find the answer to > it, and couldn't find it on the RBase website or in my > books. > > Remind me again how many columns you can have in a table? > > Because of a client who INSISTS that I design a table a > certain way, I have 748 columns. The table is fine, I can > see it and list its definition just fine. Some column > names are at the max of 18 characters. Most of the data is > REAL type. > > But if I try to insert data in it with a simple: > insert into autopsy (spleen) values 100 > (yes that is the correct table and column name) I get an > access violation. At that point the table definition > disappears and I cannot even do a Disconnect. I was > starting to design a form for it, and having no problem > with that up to the point I was at. So I wanted to insert > a row of data so I could edit using the form, and I > couldn't get data into the table! > > The client is on 7.1 (which is when this project began), > and I asked the question back then because I wanted to make > sure 7.1 could handle it. I was told that it could. But I > tried this on 7.6 and I get the same result. > > Karen
