Dear all expertise Please help
I am using PB11.
I created a datawindow using two table with the following data source
Select salary.id, salary.amount,emp.code,emp.name
from emp, salary where emp.id = salary.id
and emp.desig = 'mgr' and emp.rank ='A'
In the above SQL, I given the where condition by SetSQLSelect dynamic sql
Also I given the update properties in that data window
as follows
1. Key Column
2. Primary Key is salary.id
the column to be updated salary.amount
When I am trying to modify the salary.amount the following error message is coming
"datawindow dosnot have update capability" . But already I given the update settings.
But there is no problem occure when I am passing the where condition as retreival argument for the datawindow
Please help me to update the datawindow column salary.amount having dynamic sql and multiple table.
Regards
Jan
I am using PB11.
I created a datawindow using two table with the following data source
Select salary.id, salary.amount,emp.code,emp.name
from emp, salary where emp.id = salary.id
and emp.desig = 'mgr' and emp.rank ='A'
In the above SQL, I given the where condition by SetSQLSelect dynamic sql
Also I given the update properties in that data window
as follows
1. Key Column
2. Primary Key is salary.id
the column to be updated salary.amount
When I am trying to modify the salary.amount the following error message is coming
"datawindow dosnot have update capability" . But already I given the update settings.
But there is no problem occure when I am passing the where condition as retreival argument for the datawindow
Please help me to update the datawindow column salary.amount having dynamic sql and multiple table.
Regards
Jan