using joins

Questionsusing joins
sandy asked 7 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 7 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 7 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

6 + 12 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?