Re: LOV Question

A whole different approach I have used successfully that works with forms locking mechanisms instead of trying to code around them:

Change the NAME text item to a non-database field. Forms will not try to insert or update it in the database.

Keep your LOV mapped to NAME and ID.

Add a POST_QUERY trigger on the block level to look up the NAME from the ID when records are retrieved.

No extraneous locks, no need to wrench away commit control. Just pure forms record management.

Hope I am understanding your problem correctly and that this helps.

• Ron Olcott, President
• Interlude Enterprises
• 808-638-7775, interld808_at_aol.com

In article <354798FA.D0F4A9B0_at_trw.com>,   Martin Bronstein <martin.bronstein_at_trw.com> wrote:
>
> Try a commit_form in your trigger. The pending Update has locked the
> record.
> Martin Bronstein
>
> Jason Boesch wrote:
>
> > I have a list of values with three columns: NAME, DESCRIPTION, ID. The
> > column mapping for NAME is to a text item and ID is to an undisplayed
> > item. The description is not mapped. In the text item I am displaying
> > the NAME but I only want the ID to be stored in the database.
> >
> > I tried using an ON_UPDATE trigger on the text item, but I've run into a
> > strange problem. I can only change the item once. After requerying the
> > form and trying to update the item a second time I get a "Could not
> > reserve record" error.
> >
> > Is there something special I have to do within the ON_UPDATE trigger
> > (besides my UPDATE statement)?
> >
> > Is there a better to accomplish this task?
> >
> > Any help would be appreciated.
> >
> > Thanks!
> >
> > --
> > Jason Boesch
> > jgboesc_at_uswestREMOVETHISFIRST.com
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 17:03:11 CEST