Dear All
I have insert script for delete other records on other table , I have insert script on choice mark.delete, but have error message "Error 206 (Record is not lock)" after press delete button.


|*******************************************************
choice.mark.delete:
after.choice:
select cpdsp200.*
from cpdsp200 for update
where cpdsp200.orno = :tdsls901.order
and cpdsp200.pono = :tdsls901.pono
selectdo
db.delete(tcpdsp200, db.retry)
commit.transaction()
selectempty
endselect
|*******************************************************

Please advice me for insert script for delete records on other table after press delete button on standard form.

Thank in advance.
Wit.

Hi,

I think this link should help:
http://www.baanboard.com/programmers_manual_baanerp_help_errors_206_ENOTLOCKED

- George

Please do not make duplicate posts I will delete the others.

usually use main.table.io and the after delete section for something like this.

Please advice me for insert script for delete records on other table after press delete button on standard form.
I see you are on BaaN-5. You have to code it in DAL in the section - after.destroy.object() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_dal_after_destroy_object) and not in choice.mark.delete or main.table.io sections.

Dear NPRao
Thank you for your advice , But i don't know how to use function after.destroy.object(), then please show the sample script for use it.

Best regards,
Wit.

Refer to the existing DALs on your system for its usage. Easier way it to do a pattern match on the script sources.