Re: Forms Newbie question - help please

[Quoted] You are right, CONAME is a database item. But, doesn't it have to be in order to display properly when navigating through the records if I'm going to approach this problem using blocks?
[Quoted] Should I be populating the CONAME in a different manner? [Quoted] Maybe I should populate it in the WHEN_NEW_RECORD_INSTANCE and completely get rid of the detail blocks? Just add a field to display the company name.

"Eric Givler" <egivler_at_flash.net> wrote in message news:0YQZ5.7638$bw.675083_at_news.flash.net...
> 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
> 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 - 22:50:58 CET