Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Record size exceeds page size

    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!

  2. #2
    Join Date
    Jul 2003
    Posts
    18

    Re: Record size exceeds page size

    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

    Originally posted by dfbosse
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •