[theor]

Hello,

In my Database, i have a Table witch have no primary key. It only refer to others Tables. When i do a render(), they said there is an error in my request SQL. My code:

    public function test()
    {
      
        $crud = new grocery_CRUD();
       
        $crud->set_table('film_actor');

        $crud->columns('actor_id','film_id','priority');
     
        $output = $crud->render();

        $this->_example_output($output);

    }

Can you help me ?

Thanks a lot for a reply

[Amit Shah]

Yes, my friend, GC needs the table to have a primary key. Even if it just just refer to the other tables, if you want to use it with GC .. you need a primary key. GC is a generic library. Now imagine if it were to delete a record / edit a record / view a record - on what basis / criteria it will do it? It cannot go back and query up values for all the values in a row!!

 

And even if it just refers to other tables - there aint much cost adding a primary key.

 

Happy GCing:)