Tihanyi Zoltán
Member
Dear All,
I am relatively new in JD Edwards, and now I need some support. I have created a small interactive application, where the user can
connect some extra data, to a specific item and workcenter.
Logic:
User Select the ITEM [Find/Browse] >> Collect the related workcenters to a temp table >> Update details in temp table [Headerless Detail] >> After click ok update the prod table
The application worked fine, but I had to make the bellow mentioned changes.
- Add the MMCU field to the temporary table
- Change the temporary table and Item Branch table join from "ITM=ITM" to "ITM=ITM AND MMCU = MCU"
After this change the FAT client is working but the WEB do not save the changes.
From the log I find that, the FAT and WEB update query is different. See bellow
Does anybody has some suggestion what should be the root problem ?
Please help !
Thank you in advance
Zoltan
FAT CLIENT QUERY: (ok)
UPDATE JDE_DEVELOPMENT.TESTDTA.F55TZ018 SET
CRJOBS=?, CRMCU= ?, CRITM=?, CRWMCU=?, CRCAPU=?, CRCPSD=?, CRUSER=?, CRPID=?, RJOBN=?, CRUPMJ=?, CRUPMT=?, CRCHAR=?, CROPSQ=? ,CRSTATE=?, CRMMCU=? WHERE
( CRJOBS = ? AND CRMCU = ? AND CRITM = ? AND CRWMCU = ? )
WEB CLIENT QUERY: (not ok)
UPDATE PRODDTA.F55TZ018 SET
CRUPMJ= ?,CRUSER= ?,CRCPSD= ?,CRUPMT= ?,CRMCU= ?,CRJOBS= ?,CROPSQ= ?,CRCHAR= ?,CRWMCU= ?,CRITM= ?,CRCAPU= ?,CRSTATE= ?,CRMMCU= ?
WHERE ((CRJOBS = ? AND CRWMCU = ? AND CRITM = ? AND CRMCU = ? AND CRMMCU = ?))
Why CRMMCU is in the WHERE clause ? ? ?
I am relatively new in JD Edwards, and now I need some support. I have created a small interactive application, where the user can
connect some extra data, to a specific item and workcenter.
Logic:
User Select the ITEM [Find/Browse] >> Collect the related workcenters to a temp table >> Update details in temp table [Headerless Detail] >> After click ok update the prod table
The application worked fine, but I had to make the bellow mentioned changes.
- Add the MMCU field to the temporary table
- Change the temporary table and Item Branch table join from "ITM=ITM" to "ITM=ITM AND MMCU = MCU"
After this change the FAT client is working but the WEB do not save the changes.
From the log I find that, the FAT and WEB update query is different. See bellow
Does anybody has some suggestion what should be the root problem ?
Please help !
Thank you in advance
Zoltan
FAT CLIENT QUERY: (ok)
UPDATE JDE_DEVELOPMENT.TESTDTA.F55TZ018 SET
CRJOBS=?, CRMCU= ?, CRITM=?, CRWMCU=?, CRCAPU=?, CRCPSD=?, CRUSER=?, CRPID=?, RJOBN=?, CRUPMJ=?, CRUPMT=?, CRCHAR=?, CROPSQ=? ,CRSTATE=?, CRMMCU=? WHERE
( CRJOBS = ? AND CRMCU = ? AND CRITM = ? AND CRWMCU = ? )
WEB CLIENT QUERY: (not ok)
UPDATE PRODDTA.F55TZ018 SET
CRUPMJ= ?,CRUSER= ?,CRCPSD= ?,CRUPMT= ?,CRMCU= ?,CRJOBS= ?,CROPSQ= ?,CRCHAR= ?,CRWMCU= ?,CRITM= ?,CRCAPU= ?,CRSTATE= ?,CRMMCU= ?
WHERE ((CRJOBS = ? AND CRWMCU = ? AND CRITM = ? AND CRMCU = ? AND CRMMCU = ?))
Why CRMMCU is in the WHERE clause ? ? ?