Re: Delete_Record/Clear_Record

Problem solved - thanks anyway.

"Lesley Boughner" <lesley_at_vimich.com> wrote in message news:97h7hv026au_at_enews4.newsguy.com...
> In a pre-text item trigger I have a call to a procedure that checks to see
> if a bill has already been entered.
> If it has already been entered, I want to clear OR delete the record.
> Here's the section of code:
>
> FOR v_procheck in c_procheck LOOP
> s_exists := 1;
> clear_record;
> message ('This freight bill has already been entered.');
> End Loop;
>
> I've tried it with delete record too, but neither do anything at all. I
 get
> the message okay, and I don't get any errors.
>
> I can clear or delete the record from the toolbar.
>
> Please help.
>
> Thanks.
> Lesley.
>
>
>
>
>
>
>
Received on Wed Feb 28 2001 - 16:36:18 CET