OraFAQ Forum: Forms » Unable to update datablock with row fetched from LOV

Home » Developer & Programmer » Forms » Unable to update datablock with row fetched from LOV (Oracle forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to update datablock with row fetched from LOV [message #635838]

Thu, 09 April 2015 15:24

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.

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635884 is a reply to message #635838]

Fri, 10 April 2015 08:58

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...

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635886 is a reply to message #635884]

Fri, 10 April 2015 09:22

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

How do you know which detail record to update?

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635887 is a reply to message #635886]

Fri, 10 April 2015 09:55

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

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

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635926 is a reply to message #635888]

Mon, 13 April 2015 03:22

cookiemonster
Messages: 13963
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?

Report message to a moderator

Re: Unable to update datablock with row fetched from LOV [message #635943 is a reply to message #635926]

Mon, 13 April 2015 09:31

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...

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 08:04:36 CST 2025