How can exceed 252 bytes in an active key

apsingh
apsingh Member Posts: 14
Dear All,

I insert the number of field in an active key. I encountered the error “The fields in an active key may not exceed 252 bytes."
How can exceed 252 bytes in an active key, if you have any solution for the same please let me know.


Best Regards,
Anup Pratap Singh

Comments

  • kriki
    kriki Member, Moderator Posts: 9,127
    The secondary keys add ALWAYS the primary-keyfields that are not yet in the secondary key at the end of it. This you don't see, but it counts towards the total.

    If your key is for fast searching and less for sorting, you can restructure your key so it does not contain all keyfields but is fast anyway.
    Can you post the secondary key you want to create and also the primary key ?
    And can you also give the type and length of each key-field?
    Then I can check what you might do to fix the problem.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!