how to delete all records from table?

(0) Share

Report

Posted on by Community Member

I have a class's method to insert data from one table to another.

NOW

Data should be inserted only when the second table is empty....if the second table is NOT empty , it should call a method to delete all records from that table and then insert the data.

plz help

regards

rajesh

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

Why don't you call a truncate/delete on the table always, then you would have no records in there each time you try to insert?

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Table1 table1;

table2 table2;

select firstfast table2; //Check for a record in table2..because 1st record is enough to check data is there or not

if(!table2)

{

//Insert you logic

}

else

{

// Logic to delete Table 2

ttsBegin;

delete_from table2;

ttsCommit

}

Was this reply helpful? Yes No
Martin Dráb 239,118 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

How do you all expect this to work in a multi-user environment? One user will start putting records to the table and another user will start the same process, deleting the data for everybody. This design seems to have significant flaws.

I would return to the actual business requirement and build a different solution.

Was this reply helpful? Yes No