re: Tricky forms 3.0 problem

>Thanks, but it doesn't help. I tried it already and my
>POST-QUERY trigger makes the ONE-VALIDATE-FIELD trigger
>fire when initial values are being retrieved...thus locking
>up the form. I only want it to fire when data entry
>changes are made.
 

>If there was a way to rewrite the pl/sql in the POST-QUERY
>trigger (I refer you to my original post) I think that
>would be the simples way.
 

>- Peggy -

Peggy:

I didn't see your original post, so I'm only guessing at your problem. The following may be a solution.

When we don't want on-validate-field to fire in these types of circumstances, we use the following logic in on-validate-field, where BLOCK_NAME.FIELD_NAME is the field that you're validating.

if :system.cursor_field = 'BLOCK_NAME.FIELD_NAME' then

   /* do validation here */
end if;

Kevin Austin
austink_at_merck.com Received on Wed Feb 09 1994 - 19:41:42 CET