DELTE FIELD

ByHakan

I have a Seminar Table and SeminarTransactions table

If user delete a record in seminar table this record is must be deleted in SeminarTransactions table

How ı can do this ?

mohana_cse06

What you tried as of now?
Let us know if you tried and got any error..

ByHakan

Lt.RESET;
Lst.RESET;
IF Lt.GET(Lst."Seminar No.") THEN BEGIN
IF Lst.GET(Lt.No) THEN BEGIN
Lst.DELETE(TRUE);
Lt.No:=Lst."Seminar No.";
END;
END;
But ı dont know how ı can do this

mohana_cse06

Please try this in test environment only..

try

Lst.RESET;
IF Lst.GET(No) THEN
  Lst.DELETE(TRUE);

or Simply

Lst.SETRANGE("Seminar No.",No);
Lst.DELETEALL;

Please try this in test environment only..

ByHakan

It works thx

mohana_cse06

Welcome