Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Problems with creating validations for item fields.
Problems with creating validations for item fields. [message #173669] Tue, 23 May 2006 20:52
Messages: 5
Registered: April 2006
Location: Singapore
Junior Member

All right, here's the problem >>

I have a form on a report with columns and attributes taken from the tables in the database. 5 tables are allocated in the database, but one table is used for this "form on a report."

I named the report as a Company form, where users can add/edit company's name and details into it. However, without the use of candidate keys, i added validations to control the columns such that no two values are the same, although there is a primary key which i named it as company_id.

For the validations, i created an sql expression type "not exist" and input the following code:

SELECT company_name
from Project_COMPANIES
where company_name = :P8_COMPANY_NAME;

The code did work where no two values are the same within a particular column. However, when changes are made to update and delete, it wasn't successful unless users are forced to change the existing values to a different value. So my question was, what are the methods to set such that all three basic functions (Insert, update, delete) can work at the same time?

Previous Topic: check boxes in pl/sql
Next Topic: Report with more tables joined
Goto Forum:

Current Time: Mon Oct 19 11:16:21 CDT 2020