Developer 6.0 Forms Data Block Wizard

From: Daniel Gougeon <daniel_gougeon_at_hotmail.com>
Date: 20 Nov 2001 18:35:11 -0800
Message-ID: <db34ef81.0111201835.31c4c45_at_posting.google.com>

[Quoted] 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
        

I take the double quotes out and it will compile. if not( :STUDENT.SNAME IS NOT NULL )

Can it be done, or is it a bug??
Thanks for any help or direction you can provide. Received on Wed Nov 21 2001 - 03:35:11 CET