Milfriosc

Hello,

I already see that it's possible to set primary key to make crud for a view but I want to make crud from a table and use set relation with a view.

...
$crud->set_table('my_table');
$crud->columns('id','name','fk_streetcode');
$crud->set_primary_key('id_street','my_view');
$crud->set_relation('fk_streetcode','my_view','streetname',null,'streetname ASC');
...

with this definition there's an data base error

 ... JOIN "my_view" as "j447c7032" ON "j447c7032". = "my_table"."fk_streetcode" ...

you can see that the primary key for the view is not define  : there is a point without id_street >> "j447c7032". =

sorry for my english ....

Thank's for your answers

Hello,

I'm french (thank's google traduction and sorry for my poor language) and newbie ... so this is my question :

I use the theme flexigrid but when i search "sport" there is no result because this word has a uppercase ("Sport")  in my database.

Have you a idea to solve this problem ?

Thank's a lot