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
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
