Datawindow updation error

[jancypaul]

Please help me..

from the below data window having source code

SELECT sys_tblholrequest.id,
sys_tblholrequest.username,
sys_tblholrequest.managerid,
sys_tblholrequest.datefrom,
sys_tblholrequest.dateto,
sys_tblholrequest.approved
FROM sys_tblfitter INNER JOIN sys_tblholrequest ON
sys_tblfitter.recordid = sys_tblholrequest.employeeid
Where sys_tblholrequest.approved = 'N'

Also I am giving a dynamic sql as follows

l_str_setsql += "~n And sys_tblfitter.emailid = '"+l_str_mail+"'"

l_str_getsql = dw_main.getsqlselect()
l_str_sql = l_str_getsql + l_str_setsql
dw_main.settransobject( sqlca)
dw_main.setsqlselect( l_str_sql)
dw_main.settransobject( sqlca)
dw_main.retrieve( )


tblholrequest.id autonumber primary key
sys_tblholrequest.username varchar2
sys_tblholrequest.datefrom datetime
sys_tblholrequest.dateto datetime
sys_tblholrequest.approved char(1)

I want to update sys_tblholrequest.approved column as 'Y'

using dw_main.update(). But error is coming like 'datawindow doesnot have update capablities.' Already I given the update properties with its primary key . Please help to locate and solve my problem

 

[eri232323]

1. setsqlselect from help: "The following conditions would make the DataWindow not updatable:

· There is more than one table in the FROM clause

"
2. use the dw_1.object.datawindow.table="select * ...." mode to change the sql script. There is no syntax checking, but it work...