Unique Validation
============
Create Validation on SUPPLIER_NAME item.
Validation Name: Unique_supplier_name
Type: No Rows Returned
--> SQL Query :
select SUPPLIER_NAME
from SUPPLIER
where upper(SUPPLIER_NAME) = upper(:P8_SUPPLIER_NAME);
--> Error massage : This SUPPLIER NAME already Exists...
--> Server-side Condition:
When Button Pressed: CREATE
Not Null Validation
=============
Create Validation on SUPPLIER_NAME item.
Validation Name : Not_Null_SUPPLIER_NAME
Type: Item is Not Null
Item: P8_SUPPLIER_NAME
Error :
Error Message: You can not blank Supplier name field...
Email Validation Item Matches Regular Expression
===================================
Create Validation on "EMAIL" item.
Validation:
Type: Item Matches Regular Expression
Item: P8_EMAIL
Regular Expression: @
Error Message: Your E-mail address invalid.