Cybertronics Techno Solutions Pvt. Ltd asked 11 years ago
Hi,
1.)While implementing the php Grid view we found problems in joining multiple table and showing its result in the grid.
2.) while saving data to multiple table at the time of edit / Save or Add/Save from Php grid.
please also help me if there is any possibility to save data through 'store procedure'.
Regards
Dibyendu Poddar
2 Answers
Abu Ghufran answered 11 years ago
Hello,
1) You can use $grid->select_command to write custom SQL query with JOINs.
2) To update multiple tables, you have to use custom events (on_insert, on_update, on_delete). In those events you can also call stored procedures. For reference, please check code in demos/editing/custom-events.php
Also, add [email protected] in gtalk for chat support.
Regards,
Van Canh VuYour Answer
