Re: Developer 6.0 Forms Data Block Wizard

Daniel,

That looks like a bug in Forms Builder when it tries to create the integrity constraints. What's the complete version of Developer you are using? You may need a patch release to fix this (or hand edit the PL/SQL).

Matt.

Daniel Gougeon wrote:
>
> 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 - 06:00:46 CET