Hi all, My problem is that I am trying to delete multiple rows from a DB table at once. All the rows I'm trying to delete have the same PK as the PK is a FK from another table. This is the code I thought would work but didn't:
I've tried not using the foreach and it still gives me the exact same error:
Does anyone have a suggestion on what I should do? I need to delete multiple rows at once from the same table that have the same PK. Please let me know if this is even possible.
Discussion posts and replies are publicly visible
In my understanding, the nature of a primary key is that it is unique, and there is only a single row for one key ever.
How do you use that code snippet?
My apologies, it's a composite key table. So 2 columns make up the PK but the second key isn't the concern. I need everything that matches the first key to be deleted as it's referencing the parent object I'm trying to delete.
First, I would try to simplify that code to
a!entityDataIdentifiers( entity: cons!CTI_ENTITY_MRCM, identifiers: pv!CTI_mnthlyrevene_cntrctmnths.ctmnthlyrvCntrctmnthRcrdd )
Then, I am interested in the output.
I copied that code and got the following error:
Sorry, I would like to see the output of the a!entityDataIdentifiers() call.
There is no output configured for that node, that or I'm not sure how to locate what you are looking for.
I understand. Somehow we need to debug this. And to understand what is going on, we need a few things.
1. What exactly is going into that node?
2. How is the CDT configured?
3. How is the database table set up?
Without that, it is just guesswork.