Copying in Abstract tables - Database insert operation is not allowed on an abstract table.

(1) Share

Report

Posted on by Karel Cancara

I have three tables. An abstract one, and two others that extend it:

PlanLine (with property abstract: yes)

PlanLineTime (extends PlanLine)

PlanLineCounter (extends PlanLine)

I am trying to copy a line from PlanLine.

So I tried this in a Form where PlanLine is a Data Source:

private void copyPlanLines()
{
PlanLine copiedLine;

while select * from copiedLine
where copiedLine.MaintenancePlan == OriginaRecId.value()
{

buf2buf(copiedLine, planLine);

planLine.MaintenancePlan = maintenancePlan.RecId;
planLine.insert();
}
}

And this 👆 works!

But my Form got a bit bulky so I moved the logic into a class. And there I cannot do this:

private void copyPlanLines()
{
PlanLine copiedLine;

while select * from copiedLine
where copiedLine.MaintenancePlan == fromMaintenancePlan.RecId
{
PlanLine newPlanLine;

buf2buf(copiedLine, newPlanLine);
newPlanLine.MaintenancePlan = newMaintenancePlan.RecId;
newPlanLine.insert();
}
}

I get Database insert operation is not allowed on an abstract table.

What is the issue? How do I insert new data into an abstract table from a class?

Categories:

Dynamics 365 Supply Chain Management

All responses (3)

Answers (1)

Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report
Copying in Abstract tables - Database insert operation is not allowed on an abstract table.

Maybe you could also do something like this:
while select copiedLine where copiedLine.MaintenancePlan == fromMaintenancePlan.RecId { if (copiedLine is PlanLineTime) { ... } else if (copiedLine is PlanLineCounter) { ... } }

And by the way, you could improve performance by using a RecordInsertList rather then separate inserts.
Karel Cancara 22 on at

Like (0)

Report

Copying in Abstract tables - Database insert operation is not allowed on an abstract table.

As @Martin Dráb mentioned, I shouldn't have inserted into the abstract table.

I managed to copy all the lines I wanted from the abstract table (PlanLine) into the child tables (PlanLineTime, PlanLineCounter) by writing two separate methods looping through and inserting into both of the child tables separately.
Verified answer

Martin Dráb 230,445 Most Valuable Professional on at

Like (1)

Report

Copying in Abstract tables - Database insert operation is not allowed on an abstract table.

Inserting to an abstract table sounds wrong to me. By marking it abstract, you're saying that the table can't be used for storing data; it just contains some common fields and logic to be inherited by child tables, and you should always insert into those non-abstract tables. Do you see it differently?

I got your point that it works in your first code snippet, but maybe you shouldn't be doing it at all.