"Record Size too big for table" + error

[JasonDBurke]

Hi,
I am writing to an SQL Server 2000 database and presently writing about 1500 records with 40 fields...will be more in the future. At about 37 fields the BDE is throwing a "Record Size to big for table" error. I looked it up and it is error code 9477, Resource or Limit Error". What exactly does this mean? Does this mean that the memory allocated by BDE, i think about 64K, is not enough for the transfer of records?? How can i deal with this problem? The main database needs to hold about 80 fields and up to 100,000 records.Thanx
Jason

 

[DLanouette]

In SQL2000 each record can only have a total size of 8000 bytes.

So, if you are declaring a table that is bigger than this, that is why you are having trouble.

For example, the following table is illegal because each row is too long (9000 bytes)


create table test(
field1 char(1000) null,
field2 char(1000) null,
field3 char(1000) null,
field4 char(1000) null,
field5 char(1000) null,
field6 char(1000) null,
field7 char(1000) null,
field8 char(1000) null,
field9 char(1000) null
)


______________________________
- David Lanouette
- Lanouette Consulting, LLC
- DLanouette@Computer.org

 

[wushutwist]

You can still add the columns to the table but if you try to insert or update a record that uses more than 8K it will fail. I guess they don't know how to do row chaining/migration. Yet another limitation of SQL Server. Wushutwist

 

[foxdev]

The problem is complicated by varchar fields; you could have a table whose sum total of varchar(n) columns is more than 8060 bytes (the max row size), but as long as no single row actually uses more than that number, it will work. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause