E9.2 FAT and WEB different update query

  • Thread starter Tihanyi Zoltán
  • Start date

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 ? ? ?
 
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 ? ? ?
Already found.

Added to CRMMCU to primary key, and changed the join type to INNER. Its ok now.
It was my mistake.

Regards
Z
 
Back
Top