Re: Deleting certain records from detail block on commit

Hi

You can use the on-insert trigger to check if quantity is null or not.

If it is not null, you should call the built-in insert_record to effectivelly insert the record in the database. If it is null, you should do nothing, so the record will not be inserted...

I never tried it myself, but I think it should work.

hth
Luis Cabral

avril7_at_yahoo.com (Av) wrote in message news:<4c29054a.0206030602.24dca7bb_at_posting.google.com>...
> I have a detail block which is populated with all the possible records
> by default, but I only want the records for which a value is entered
> in the quantity field to be saved to the database.
>
> I have a key-commit trigger on the block that which deletes all
> records with a NULL quantity. This works fine. The problem is that
> if the user issues a COMMIT from the master block, this key commit
> trigger does not fire and all records including the ones with null
> quantity are saved.
>
> My question is, how do I remove certain records from the detail block
> on commit?
>
>
> Thanks
> Av
Received on Mon Jun 10 2002 - 02:01:14 CEST