Dev 6 Data block Wizard problem

From: Melody J. Pike <coffee_at_mail.csuchico.edu>
Date: Fri, 20 Jul 2001 15:19:11 -0700
Message-ID: <Pine.GSO.4.02.10107201517100.1575-100000_at_mimas.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. Thanks for any help or direction
you can provide.

-Melody Received on Sat Jul 21 2001 - 00:19:11 CEST

Original text of this message