jplessis
Member
I have a business view built on 2 tables correctly joined.
This business view is used in a headerless detail form. The insert is working but update is failing.
After debugging the issue, I noticed the following things :
- during insertion, I see 2 insert statements, one on table A and one on table B. On screen values are used and everything goes fine.
- during update, I see 2 statements too. But the A table update is correct while the B table update is wrong. It uses the new value in the where clause of the statement. For example, if my GC X has been set to 5 by the user, the update will be like "UPDATE B SET X = 5 WHERE X = 5;". I can't find a way to tell JDE to use the old GC value in the where clause.
As a beginner on JDE, I feel really stuck on this problem. Any idea or advice would be greatly appreciated. Thanks to all JDE gurus.
This business view is used in a headerless detail form. The insert is working but update is failing.
After debugging the issue, I noticed the following things :
- during insertion, I see 2 insert statements, one on table A and one on table B. On screen values are used and everything goes fine.
- during update, I see 2 statements too. But the A table update is correct while the B table update is wrong. It uses the new value in the where clause of the statement. For example, if my GC X has been set to 5 by the user, the update will be like "UPDATE B SET X = 5 WHERE X = 5;". I can't find a way to tell JDE to use the old GC value in the where clause.
As a beginner on JDE, I feel really stuck on this problem. Any idea or advice would be greatly appreciated. Thanks to all JDE gurus.