I have and editgrid, and when performing and update on a field, message is returned that 'record was updated' however it is not in the database..
i have a feeling it is with the Datasource, which has joins to other files, that are resulting in this....
is this a bug ?, or is what i'm trying to achieve not even possible with my Sql Statement ..
PS. the files in the join are views...
(i've left out some fields)
this is what is defined in my editgrid
Image 005.png
In the grid, i want to change f.e the address nbr
Image 006.png
when double clicking, i get the edit window
Image 007.png
when updated.. notificiation is sent
Image 008.png
but the record is not updated.. after refreshing nor after verifying in the Database
Don't see any messages neither in the console log, nor on the iSeries...
i have a feeling it is with the Datasource, which has joins to other files, that are resulting in this....
is this a bug ?, or is what i'm trying to achieve not even possible with my Sql Statement ..
PS. the files in the join are views...
(i've left out some fields)
Code:
SELECT ecxseller, ecxplant, ecytest, eccsite, ... ecnlvad, FROM edicusppf LEFT OUTER JOIN cxxv2 ON eccsite = cxcsite and cxcuno = ecnklnt LEFT OUTER JOIN coblavc ON eccsite = lacsite and lanklnt = ecnklnt and lanlvad = ecnlvad ORDER BY ecytest, ecnklnt, ecnlvad
Image 005.png
In the grid, i want to change f.e the address nbr
Image 006.png
when double clicking, i get the edit window
Image 007.png
when updated.. notificiation is sent
Image 008.png
but the record is not updated.. after refreshing nor after verifying in the Database
Don't see any messages neither in the console log, nor on the iSeries...
Comment