Developer 6.0 Form Data Block Wizard

I am using Developer 6.0 and Oracle 8i. I am using the Form Builder Data Block Wizard and Layout Wizard together.

Question:
How do I stop the Wizard from adding Double Quotes around my Not Null constrains
and yet still enforce data integrity?

When I run my Form here is what happens:

The below information is from the PL/SQL Editor. (see error displayed below)

--

• Begin default enforce data integrity constraint SYS_C002288 section
  --
  if not( ":STUDENT.SNAME" IS NOT NULL ) then message( 'WHEN-VALIDATE-ITEM trigger failed on field - ' || :system.trigger_field ); raise form_trigger_failure; end if;
  --
  
• End default enforce data integrity constraint SYS_C002288 section
  --
  

ERROR MESSAGE:
Error 201 at line4, column9

	identifier ':STUDENT.SNAME' must be declared
	Error 0 at line4, column1 
	statement ignored.

I take the double quotes out and it will compile. Thanks for any help or direction
you can provide.

-Melody
coffee_at_csuchico.edu Received on Fri May 11 2001 - 02:08:28 CEST