?Abase only allows nine foreign key in a table?

  • Resolved joseyaz

    (@joseyaz)


    9 years, 7 months ago

    Always get the message, that attachment, if I have more than 9 foreign key in a table.
    Is a limitation of abase? Is it my fault? Is it possible to hide the error message?

    A level of MySql (I use plugin Adminer) and works well.

    Non-Fatal Error (1245)
    JOIN table maximum depth of 20 reached. You May Have a recursive foreign key specification in one of your tables.

    I gave her lap, looked up and down, everything.
    Thank you very much community, and Richard Halverson by the plugin.

    https://www.ads-software.com/plugins/abase/

Viewing 1 replies (of 1 total)
  • Thread Starter joseyaz

    (@joseyaz)

    No, abase hasn`t limitation on foreign key, it’s my mistake. I’m sorry.

    I re-create the table, and created 14 foreign keys and working properly.

    The difference between before and now I’ve been creating foreign keys using:

    [abase sql = “ALTER TABLE xxxxx ADD FOREIGN KEY (xxxx_key) REFERENCES titles (xxx_id) ON UPDATE RESTRICT ON DELETE RESTRICT”]

    In the first case I had created the foreign keys using the plugin Adminer

    Thanks.

Viewing 1 replies (of 1 total)
  • The topic ‘?Abase only allows nine foreign key in a table?’ is closed to new replies.