Re: Insertion in DEV - FRM40508

Click Help,Display Error on the form's menu immediately after the 40508 error. You may find an invalid column name or such. Do you have a field in the block that is not a column in the table? Or, is there a NotNull column in the table that you are not filling in the form?

"Ludwig Mallia" <lumar_at_fastnet.net.mt> wrote in message news:390fbff2$1_at_news.waldonet.ent.mt...
> I have created a database with security measures (roles and privileges).
> The problem I have is that I can not insert into the tables from
 Developer.
> I am using Oracle 8.04 and Dev6.0. In the developer I am logging as the
> owner of the tables and still it would not let me insert. . The form I
> have, has a single block, named Products. It displays the attributes of
 the
> product. It has a foreign key to suppliers and one for category, both are
> shown as LOVs. When I hit the Save button, with is an event on button
> presses (do_key('commit_insert')) it generates the following
> ERROR........FRM-40508.
>
>
> any ideas?
>
> cheers
> Ludwig
>
>
Received on Wed May 03 2000 - 00:00:00 CEST