Home » Developer & Programmer » Forms » Oracle Forms: clear_block(no_validate)
Oracle Forms: clear_block(no_validate) [message #77973] Thu, 27 December 2001 14:01 Go to next message
Blair
Messages: 3
Registered: December 2001
Junior Member
Does anyone know why I cannot get past the field validation on my form. When I try to clear the block without validation it keeps getting hung up as it tells me I must enter a value in the field. The field is marked as required as set out by the properties. But i thought if you added a no_validate to the clear block it would override this. Any ideas? Here is the code:

go_block('employee_main');
clear_block(no_validate);
execute_query(all_records);

Thanks

----------------------------------------------------------------------
Re: Oracle Forms: clear_block(no_validate) [message #77974 is a reply to message #77973] Thu, 27 December 2001 15:22 Go to previous message
waris
Messages: 115
Registered: November 2001
Senior Member
Hi Blair...

yep u r right..after seeing ur Question i too did try this out but its quite surprising that clear_block(no_validate) is not overriding the
required property...

anyway i hope u could have solved ur problem by using anyone of the fallowing item level properties and then calling clear_block(no_validate)

set_item_property(item_id,Item_Is_Valid,property_true);

or

set_item_property(item_id,required,property_false);

Wish u a very Happy New Year

Cheers
waris

----------------------------------------------------------------------
Previous Topic: Re: free material for oracle
Next Topic: Frm-40735:Post.query trigger raised unhandled exception Ora-01403
Goto Forum:
  


Current Time: Thu Mar 28 08:00:12 CDT 2024