Re: Build Forms - Need Data?

I think what is happening is that in one of your table definitions there is column that is *optional* and is a part of *mandatory* foreign key constraint.

To fix this either make the foreign key constraint optional or make the column mandatory. You can do this via the data diagrammer.

BTW, you do not need any data in the tables when you generate forms in Designer/2000. The only requirement is that the tables exist in the database so that the forms generator can compile the form.

HTH,
Sameer

> Jenny Chang wrote:
> >
> > When generate Forms using Design/2000 Release I,
> > does databse need to be loaded data first? Since
> > I got a lot of the following error message:
> >
> > CGEN-01406: Require DB constraint to ensure all columns not
> > null for mandatory key...
> >
> > Your answer will be appreciated if you know Designer/2000.
> >
> >
> > --
> > Jenny Chang
> > USGS-NMD-WMC
> > 650-329-4229
> > jchang_at_igsmn002.wr.usgs.gov
>
> --
> Valery A. Sorokin
> ProSoft, Russia, Moscow, Information Systems Division
> Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
> E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
> http://www.dd.ru
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 19 1999 - 18:20:44 CET