(unknown charset) Re: Forms & List items
Date: Tue, 03 Dec 2002 09:43:05 +0000
Message-ID: <3DEC7CA9.1D955521_at_spammotel.com>
why would you want to do that?
you pick a field from a LOV for a reason.
ie. it is the value that you want.
if you decide then to update the field then
you should be looking at a post-insert or
post-update trigger to make the change to the
relevant LOV record.
in addition when you set up the LOV return fields
set the property validate from list to FALSE.
and set the automatic refresh property on the LOV to TRUE.
so that it allows the value you put in and refreshes
the LOV everytime with new data.
>Hello,
>
>I use Forms version 6.0.8.8.0, and I would like to be able to update
some
>fields in a table with a given condition. To do that, I've built a LOV
based
>on a query which retrieve the fields I want to update, and ask my form
to
>display this LOV clicking on a button for the fields in my form being
filled
>in with the LOV's informations.
>The problem is that it seams to be impossible to insert or update a
field
>that comes from a LOV list!!
>
>Is someone know how to be able to update the field after getting it
from a
>LOV?
>
>Thanks for all proposition
>
>Regards.
colleen wrote:
> Hi,
>
> I am having this same exact problem with a form I created. I was
> wondering if any one has found a solution to this problem yet.
>
> Regards,
> Colleen
>
> --
> colleen
>
> Posted via http://dbforums.com
-- Suzuki SV650S - plop. Gone. Kwak ZX-6R J2 - hear the roarReceived on Tue Dec 03 2002 - 10:43:05 CET