using joins

Questionsusing joins
sandy asked 6 years ago

I can insert, update, delete the rows from grid when i am working with single table. But when i go for multiple tables i am facing problem in updateing and deleting the grid data. By using Mysql join, i am loading data, but i cant insert, update or delete rows.
How to solve this problem?

Thanks.

2 Answers
ramakrishna answered 6 years ago

Hi,
Here i'm using "fw_activity_master" one table and "fw_application_master" one more table.using inner join and taken "Applicationname " name..

$g->select_command = "SELECT * FROM (SELECT i.ACM_slno, i.AM_slno, i.CM_slno,i.Activityname, i.Formname,i.Status, i.Startdate, i.Enddate, i.Txnuser, i.Txndate,o.Applicationname FROM fw_activity_master i INNER JOIN fw_application_master o ON o.AM_slno = i.AM_slno) o ";

Abu Ghufran answered 6 years ago

Hello,

Basic version allow one table DML operations.
For multiple table or complex business logic, you need to use custom on_update, on_insert, on_delete events, that are part of paid version.

Select sql will work fine with joins. Limitations is with DMLs.

Regards,

Your Answer

5 + 14 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!