Skip to main content
Solved

detail tab with view shows display message

  • 12 April 2024
  • 5 replies
  • 94 views

hi,

We use a view in a detail tab where we combine two tables, a record can be added in the row. We use an instead of trigger to insert the records in het underlying tables. After adding the record, the message “saved data can not be displayed on this screen”, but surprise, the new record is shown!

 

 

Because of the two tables, two primary keys are added in this view, can this be the problem? Should I create a dummy primary key for this view?

Anybody an idea how to fix this?

This topic has been closed for comments

5 replies

Userlevel 7
Badge +23

Hi Tejo,

I believe the primary key can indeed result and prevent this behavior. Try and have a primary key from the List to Shipment package measurements that enforces a strong relationship. E.g. Shipment_id ↔ Shipment_id

Userlevel 3
Badge +5

hi @Mark Jongeling, problem also in ticket 9207S cause I have other problems with the shipment_id column. I’ll add fix here when available.

Userlevel 3
Badge +5

Support says it is working in 2024.1 so this issue is 2022.2 related. Will try myself when we level up to SQL2019.

Userlevel 7
Badge +23

Hey Tejo,

Great! Be sure to start preparing to upgrade as 2022.2 will go out of support after this month 

Userlevel 3
Badge +5

Edit: Support could reproduce the same error in 2024.1, now waiting for hotfix or workaround.