Home » SQL & PL/SQL » SQL & PL/SQL » Saving records selected by a lov
Saving records selected by a lov [message #1473] Sat, 04 May 2002 07:30 Go to next message
Faisal
Messages: 16
Registered: November 2001
Junior Member
hi i need help badly!

if i try to update a record in oracle forms that i have selected using a lov it will not let me save the record whereas it will let me normally

please help i am in a real dilema here!!!!!!!

thanks in advance
Re: Saving records selected by a lov [message #1491 is a reply to message #1473] Mon, 06 May 2002 11:33 Go to previous message
Munish
Messages: 21
Registered: November 2001
Junior Member
Once you select from lov, where are you putting it?
If you are putting the value into a database column, then that value gets inserted into the table and you might have a unique constraint on the table.

Try this :-
from lov..hold the value in a dummy field or Global field. Once that is done, then u can go ahead and update the table.

hope this helps :)
Previous Topic: Simple Question about sql
Next Topic: query dates
Goto Forum:
  


Current Time: Tue Apr 30 16:35:47 CDT 2024