Oracle Forms Validations

Hi Everybody.....

1) My query is like i have a form by name employeetest

2) I a form i have two canvases

3) There are many test_fields and list_items in the canvas

4) What my query is like.....

4a) If i don't fill any of the item or text_filed i need to get a message

4b) And Next is when i want to go for the next canvas when button
click "NEXT" then it should be validated and show show me the
message unless i complete filling the form with proper data i
should not go for the next canvas....

Hope so everyone is clear......I request you all pls kindly help me how to do
validations.....

Thank you
With Regards
Mohan

infoviewmohan
Profile Answers by infoviewmohan Questions by infoviewmohan
Jul 15th, 2008
1
2518

Questions by infoviewmohan answers by infoviewmohan

Apps Technical

Answer

Showing Answers 1 - 1 of 1 Answers

rajivgupta780184
Profile Answers by rajivgupta780184 Questions by rajivgupta780184

Aug 10th, 2008

You can do this validation in two ways
1> You can select all the feild at a time and click F4 or go to the properties of that and make the required feild(required property) =YES

2>You can also do it through coding
i.e

begin
If :block1.textbox1 is null and :block1.textbox2 is null and.......:block1.textbox..n is null then
Message('Please fill all the requied feild');
Message('Please fill all the requied feild');
end if;
exception when others then
message(sqlerrm);
message(sqlerrm);
end;

For user flexibility you put astrik sign in all the feild so that user can understand that all are required.
Thanks
Rajiv