tosa500

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [ABASE] Problem displaying table with foreign keys
    Thread Starter tosa500

    (@tosa500)

    12 years, 6 months ago

    One more suggestion:
    Let’s say we have a table view with rlink which takes us to another page where we add/update/delete records. I’d like to have a url in the “form” shortcode which would take me back to updated table. Could you do that?
    Cheers

    Forum: Plugins
    In reply to: [ABASE] Problem displaying table with foreign keys
    Thread Starter tosa500

    (@tosa500)

    12 years, 6 months ago

    Hello Richard. Sorry for a long delay.
    I can confirm installing the latest version fixed my problem.
    I’ve got another question:
    In example 8 there is a table class shown with all the elements of table teachers. But if I don’t want all the fields from table teachers to be shown, I can’t do that. Would it be possible for you to add
    columns=”name,id_teacher|forename,id_teacher|surname” so we could control what fields we want to display, similar to example 7?

    One thing that is also missing in your plugin, or I missed that in your documentation is how to delete a record. Is it possible to do that?

    Thanks a lot!

    Forum: Plugins
    In reply to: [ABASE] Problem displaying table with foreign keys
    Thread Starter tosa500

    (@tosa500)

    12 years, 7 months ago

    Thank you for the reply. Result from the above shortcodes:
    CREATE TABLE class (
    id_class int(1) NOT NULL AUTO_INCREMENT,
    name int(11) NOT NULL,
    id_teacher int(1) NOT NULL,
    PRIMARY KEY (id_class),
    KEY id_teacher (id_teacher),
    CONSTRAINT class_ibfk_1 FOREIGN KEY (id_teacher) REFERENCES teachers (id_teacher)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1

    CREATE TABLE teachers (
    id_teacher int(1) NOT NULL AUTO_INCREMENT,
    forename varchar(16) NOT NULL,
    surname varchar(16) NOT NULL,
    phone varchar(10) NOT NULL,
    PRIMARY KEY (id_teacher)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Viewing 3 replies - 1 through 3 (of 3 total)