I'm trying to create a large table (12000 bytes), but keep getting the error "record size exceeds page size". It appears the maximum page size (I'm using 2000i SP4) is 4096 bytes. Is there any way to create a table greater than 4096 bytes? Thanks!

Hello,

Yes, you may create a table greater than 4096 bytes. The maximum page size is 4096 bytes, however.

Here's some information that should help you.

For the limits for the Pervasive relational engine interface, see page 2-2 in SQL Engine Reference. You may view a PDF of the SQL Engine Reference here: http://www.pervasive.com/support/tec...l2k/sqlref.pdf

For additional information about page types and size, refer to chapters 4 and 5 in the SDK Programmer's Guide: Btrieve Fundamentals and Designing the Database. You may view a PDF of the Programmer's Guide here: http://www.pervasive.com/support/tec...k/prog_gde.pdf

Regards,
Tim
Pervasive Technical Publications