You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Same Record at Level 0 and Level 1

4 replies [Last post]
gpawar.ps's picture
User offline. Last seen 2 years 3 weeks ago. Offline
Joined: 02/06/2009
Posts: 10

We have added same record at Level 0 and level 1. Level 0 is having all key fields while Level 1 contains only one key field (i.e. EFFDT) and two non-key fields.
When we are trying to update existing row then it is working correctly but when we are trying to Add a New Value for current date, and try to Save the componet then it is throwing 'Data Conflict' Error. and for either previous date or future date it is Adding two rows- one row for the history/future date and one row for current date.

Please help us to resolve it.

Thank you in advance.

Regards,
Ganesh Pawar

Guest's picture
Guest (not verified)
Re: Same Record at Level 0 and Level 1

the data conflict error may be because the row which you are trying to add doesn't have a unique key combination and may be it is clashing with the values of keys for rows already present....my suggestion to you is you can add a field line number to your level 1 record and increment it everytime a row gets added and make it as a key apart from EFFDT.

Guest's picture
Guest (not verified)
Re: Same Record at Level 0 and Level 1

Create different record for level 0 and 1.

Ashar's picture
User offline. Last seen 2 weeks 20 hours ago. Offline
Joined: 03/26/2008
Posts: 214
Re: Same Record at Level 0 and Level 1

Strange. DEPARTMENT_TBL component in HR has same record at level 0 & 1 and it works fine.

Hari_aindian's picture
User offline. Last seen 4 weeks 11 hours ago. Offline
Joined: 08/02/2010
Posts: 78
Re: Same Record at Level 0 and Level 1

May be a trace will help you to identify... Use SetTracePC to find the exact trace of your component code alone

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.