Home » Developer & Programmer » Forms » LOV (merged 3) forms 6i ,window 2003 server
icon5.gif  LOV (merged 3) forms 6i ,window 2003 server [message #416746] Tue, 04 August 2009 03:30 Go to next message
kilimanjaro
Messages: 134
Registered: May 2009
Location: Tanzania
Senior Member
Hi OP. Im in a bit of trouble here. I want to display an LOV which calculates quantity from several tables and those tables have several rows .how do I do that in oracle forms 6i?? each table has a unique code and quantity .
Re: LOV [message #416748 is a reply to message #416746] Tue, 04 August 2009 03:39 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you provide an example (your input and desired output)?

I guess that - once you succeed to write a SELECT statement that returns what you need - putting this query into a Record Group might do the job.
Re: LOV [message #416751 is a reply to message #416746] Tue, 04 August 2009 03:58 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
This is not helping... Tell what calculation are you performing and on what basis...

Illustrate your reply with a simple example
Re: LOV (merged 3) forms 6i ,window 2003 server [message #416800 is a reply to message #416746] Tue, 04 August 2009 06:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
milikiel,
Getting an answer to your question is not proportionate to your number of posts.
It is, how better you can explain your issue.

By
Vamsi

PS: Please don't cross post. Read the forum guide.
Re: LOV [message #416840 is a reply to message #416748] Tue, 04 August 2009 12:33 Go to previous messageGo to next message
kilimanjaro
Messages: 134
Registered: May 2009
Location: Tanzania
Senior Member
i greatly appreciate your quick response.Thankyou very much .OK i have a form which has code_number,unit and quantity. i also have three tables, sales,purchases and outdated.both tables have code_number,unit and quantity. now i want the LOV which will take the quantity from purchases and deduct the sum quantity of sales and outdated by code_number. maybe like :purchases.quantity-sum(:sales.quantity+:outdated.quantity).
Re: LOV [message #416854 is a reply to message #416840] Tue, 04 August 2009 15:00 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you could perhaps create a view (a database object) which would contain all the calculations, and then write a simple SELECT statement against this view to populate the LoV.
Re: LOV [message #416923 is a reply to message #416854] Wed, 05 August 2009 03:23 Go to previous message
kilimanjaro
Messages: 134
Registered: May 2009
Location: Tanzania
Senior Member
Thankyou Littlefoot.but still am not getting what i want. may be you should help me with the following.
:purchases.quantity-sum(nvl(:outdated.quantity,0))
where :purchases.item_code=:outdated.item_code

Eveything is fine if there is a corresponding data in outdated table.the problem is i dont get :purchases.quantity if no data in outdated table with the same item_code as in purchases table.

am tryin to have an LOV.

PLEASE ASSIST.
Previous Topic: picture / Image Displaying using bfile data type
Next Topic: Icon on Selected Node
Goto Forum:
  


Current Time: Sun Dec 04 20:27:05 CST 2016

Total time taken to generate the page: 0.07708 seconds