Re: Forms Newbie question - help please

[Quoted] You might want to try the menu option: Display Error When you are running your form and see what is going on. From what it sounds like, you Accidentally made the BillToBlock.CONAME a database column. When you do this, Oracle will try to write it's contents to the table that the block is [Quoted] tied to. If it's not a column in the table, you get an error. Check the properties of the CONAME column.

"Lesley" <lesley_at_vimich.com> wrote in message news:bWKZ5.66527$J32.2569591_at_news20.bellglobal.com...
> Yes I'm having a problem - sorry I think I deleted that part.
>
> FRM-40508 ORACLE unable to insert record. When I try and change the
 name
> & save it.
>
> As soon as I remove the association in the BILLTOBLOCK.CONAME to the LOV,
 I
> can insert and update records again.
> Not the Billtocoid of course. So something isn't working right.
>
> Is this the best method for what I'm trying to do?
>
> Thanks for any input.
> Lesley
>
>
>
>
> "Matt B." <mcb_at_ds.znet.com> wrote in message
> news:t3dusm45p8h277_at_corp.supernews.com...
> > "Lesley" <lesley_at_vimich.com> wrote in message
> > news:FKsZ5.74252$i%4.2421701_at_news20.bellglobal.com...
> > > Hello everyone.
> > > Could someone tell me the best way to do this.....
> > >
> > > Here's the fields of concern in the COMPANYDIR table:
> > > COID
> > > CONAME
> > > BILLTOCOID (fk to coid)
> > >
> > > Here's exactly what I've done....
> > >
> > > Created an additional Block (BILLTOBLOCK) that consists of BILLTOCOID
 and
> > > CONAME
> > > There's a relationship: BILLTOBLOCK.BILLTOCOID = COMPANYDIR.COID on
 the
> > > master block.
> > > I am only displaying the BILLTOBLOCK.CONAME on the canvas
> > >
> > > I have created an LOV (LOV_BT) based on the Query: Select COID,
 CONAME
> > > FROM COMPANYDIR.
> > > Column Mapping: COID mapped to BILLTOBLOCK.BILLTOCOID
> > > CONAME mapped to BILLTOBLOCK.CONAME
> > >
> > > The BILLTOBLOCK.CONAME properties:
> > > List of Values = LOV_BT
> > > Validate from list = Yes
> > >
> > >
> > > I want the user to be able to change the BILLTOBLOCK.CONAME and have
> > > BILLTOCOID updated with the COID in the same record.
> > >
> > > Am I doing something wrong, or is there an easier way?
> > > Thanks very much.
> > > Lesley
> >
> > Well, if you are asking if you're doing something wrong, then does that
 mean
> > you are having a problem? If you're getting an error or something,
 please
> > share.
> >
> > Otherwise it looks like it should work.
> >
> > -Matt
> >
> >
>
>
Received on Wed Dec 13 2000 - 21:26:36 CET