items table records that are used in other tables are being deleted when i try to delete the records that are not used.i want to delete only those records which are not used.

(0) Share

Report

Posted on by Sulav Thapaliya

Hello All

I have created a table called MODEL and I have created a page called MODEL VERSION LIST and MODEL VERSION CARD whose source table are ITEM table.I have also created a page called MAKE LIST and MAKE MODEL whose source table are MODEL table.The field Model Code are used in ITEM and MODEL table as well.

What I am trying to do is, I am trying to delete the item record from the MODEL VERSION LIST that are not used in ITEM table.

I have written the code on MODEL table in OnDelete trigger as

item.setrange("model code","code");

if item.findfirst then begin

ERROR('The model code is in use.It cannot be deleted from the item table');

end;

But the code does not seem to be working at all.

*This post is locked for comments

All responses (4)

Answers (1)

Sulav Thapaliya 2 on at

Like (0)

Report

RE: items table records that are used in other tables are being deleted when i try to delete the records that are not used.i want to delete only those records which are not used.

The problem has been solved.

Thank you for your concern
Sulav Thapaliya 2 on at

Like (0)

Report

RE: items table records that are used in other tables are being deleted when i try to delete the records that are not used.i want to delete only those records which are not used.

The problem has been solved now.

Thank You For Your Concern.
Verified answer

keoma 32,675 on at

Like (0)

Report

RE: items table records that are used in other tables are being deleted when i try to delete the records that are not used.i want to delete only those records which are not used.

when you remove a model record, do you call delete or delete(true)? the ondelete trigger is only called, when delete(true) is used.
mmv 11,465 on at

Like (1)

Report

RE: items table records that are used in other tables are being deleted when i try to delete the records that are not used.i want to delete only those records which are not used.

Hi,

Where the above code is written? Table or Page?