Re: Form Builder : Insert new records in a Master-Detail relationship within the same table

This is the correct answer. show_error is the appropriate debugging built in to use here.

Another way to debug this... run your form .do your commit. When the error pops up press Shift F1. This will bring up a popup screen showing you a more detailed error as to what is wrong with your commit.

It usually means you violated a constraint or your primary key is null.

"Surfnet" <j.r.l.m.batailleVERWIJDER_DIT_at_uva.nl> wrote in message news:abuen4$t44$2_at_news.surfnet.nl...
> Hello Black Unicorn,
> hard to say.
> Try inserting a record and after the FRM message pops up, click it away,
go
> to the Forms 'Help' menu and select 'Show error'. That might give you the
> database error to help you on your way.
>
> Regards, Joost
>
> --
> Joost Bataille
> University of Amsterdam ICT centre
> www.ic.uva.nl
>
> remove VERWIJDER_DIT to reply
> "The Black Unicorn" <tbu_at_pandora.be> wrote in message
> news:pan.2002.05.15.13.16.35.152564.13432_at_pandora.be...
> > Hello,
> >
> > I've got another problem. I have two data blocks, one with a list of
> > usernames (shows 10 records) and one with a one-record display of all
the
> > fields in that same table. They are connected with a simple join.
> >
> > The problem is that I can't Insert new records in the Detail block, when
> > I try to it gives a FRM-40508: ORACLE ERROR: Unable to INSERT record.
> > I understand that the problem comes from the relation between the two
> > blocks, but I have no idea how to solve it.
> >
> > Can anyone help me out with this ?
> > tia
> > Davy Herben
>
>
Received on Sun May 26 2002 - 03:14:12 CEST