[jariberi]

Hello! Sorry for my english, i have a problem.

 

I have 2 tables:

 

entidades (cuit, denominacion, direccion)

detalle_clientes (idclientes, limite_credito)

 

and a view:

clientes defined as:

 

 

select entidades.cuit, detalle_clientes.idclientes, entidades.denominacion,entidades.direccion, detalle_clientes.limite_credito from entidades inner join detalle_clientes on entidades.cuit=detalle_clientes.entidades_cuit;

 

Show the data, the grid, but when i want add or edit, not work. No inform any error, just freeze.

 

Here is my code:

 

$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('clientes');
$crud->set_subject('Clientes');
$crud->set_language('spanish');
$crud->set_primary_key('idclientes','clientes');
$crud->columns(
       'idclientes',
       'cuit',
       'denominacion',
       'direccion',
       'limite_credito'
       );


     $output = $crud->render();
$this->load->view('entidades/clientes',$output);

 

 

Can you help me please?

 

Thanks!!!!

 

 

 

 

[davidoster]

Hello and welcome!

 

This SQL "select entidades.cuit, detalle_clientes.idclientes, entidades.denominacion,entidades.direccion, detalle_clientes.limite_credito from entidades inner join detalle_clientes on entidades.cuit=detalle_clientes.entidades_cuit;", where is it in your code?

[victor]

my small daughter says in this case 'nu-nu-nu'. :)

[Sanjay Pant]

I faced a similar problem earlier and realised that grocery crud does not work with views. I created a custom model using the sql used in view along with other tables and was able to get the desired output.

[jariberi]

The SQL is how is defined the view in mysql, is not in the code.

[davidoster]

The SQL is how is defined the view in mysql, is not in the code.

 

Oh! I am sorry! It's a MySQL view! Allright!

Why do you need to use a view? Is there a specific reason?

 

 

 

I faced a similar problem earlier and realised that grocery crud does not work with views. I created a custom model using the sql used in view along with other tables and was able to get the desired output.

It's true what Sanjay says. GC doesn't work well with MySQL views. It was build for using views to be honest!

Try the custom model, it might give you the solution you need. If not come back here to try to find another solution.

[mnish]

GC not work with custom sql join.

set_relation show all rows from second table.

[davidoster]

GC not work with custom sql join.

set_relation show all rows from second table.

 

Please post your issue here.