Home » Developer & Programmer » Forms » Unable to update datablock with row fetched from LOV (Oracle forms 10g)
Unable to update datablock with row fetched from LOV [message #635838] Thu, 09 April 2015 15:24 Go to next message
megha2525
Messages: 62
Registered: June 2012
Location: columbus
Member
Hi All,

I am working on Oracle forms 10g.

I do have a new requirement which would enhance an existing form.

This is a master detail form based on Transactions table and Transaction_items table.

The Transaction Items data block has the fields.
item_name,
Quantity,
Unit_of_measure,
Unit Price.

Down at the bottom on the screen is a button called Copy_pre_transaction_log.
When a user clicks on Copy_pre_transaction_log an LOV pops up.

Consider an example where there are some transaction_items retrieved from the database.
A user selects a record from the LOV , clicks ok.
Right now, a new line item is being created in the transaction_items data block.
How can I update an existing transaction_item with the record from the LOV?

Thanks
Megha.
Re: Unable to update datablock with row fetched from LOV [message #635884 is a reply to message #635838] Fri, 10 April 2015 08:58 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
One way would be to return the values from the LOV into Non-displayed items in a Control Block and then assign the values from the Non-Displayed items to the record you want to modify.

Craig...
Re: Unable to update datablock with row fetched from LOV [message #635886 is a reply to message #635884] Fri, 10 April 2015 09:22 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
How do you know which detail record to update?
Re: Unable to update datablock with row fetched from LOV [message #635887 is a reply to message #635886] Fri, 10 April 2015 09:55 Go to previous messageGo to next message
megha2525
Messages: 62
Registered: June 2012
Location: columbus
Member
How do you know which detail record to update?

I have a stop alert that would popup saying
"Cursor must be in item name field of transaction items"


Thanks
Megha

[Updated on: Fri, 10 April 2015 09:55]

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635888 is a reply to message #635884] Fri, 10 April 2015 10:00 Go to previous messageGo to next message
megha2525
Messages: 62
Registered: June 2012
Location: columbus
Member
Hi Craig,

One way would be to return the values from the LOV into Non-displayed items in a Control Block and then assign the values from the Non-Displayed items to the record you want to modify.



When a user picks a record from the LOV , each record may actually have more than one child record .
In such case, can you suggest a way to handle this?

Thanks
Megha
Re: Unable to update datablock with row fetched from LOV [message #635926 is a reply to message #635888] Mon, 13 April 2015 03:22 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I think you need to describe the situation in more detail.
What exactly does the LOV display? What query is used to populate it?
How exactly does the LOV data relate to the contents of the detail block?
Re: Unable to update datablock with row fetched from LOV [message #635943 is a reply to message #635926] Mon, 13 April 2015 09:31 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
I agree with CookieMonster, before I offer any other suggestions, it would be very helpful to know the answers to CM's questions.

Craig...
Previous Topic: Failure of server APACHE bridge
Next Topic: ORA-00904: "OP" invalid identifier ORA-06512: at :WEBUTIL.WEBUTIL_DB", line 50
Goto Forum:
  


Current Time: Fri Aug 14 09:37:27 CDT 2020