Developer 6.0 Data Block Wizard

From: Eon Pike <rpike_at_csuchico.edu>
Date: Thu, 10 May 2001 16:49:53 -0700
Message-ID: <3AFB2921.9F308D58_at_csuchico.edu>


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. Any help or direction is greatly appreciated.

-Melody Pike
coffee_at_csuchico.edu Received on Fri May 11 2001 - 01:49:53 CEST

Original text of this message