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: 21146
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: 551
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: 2108
Registered: October 2003
Location: Hyderabad, India
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: 21146
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: Fri Aug 18 04:04:48 CDT 2017

Total time taken to generate the page: 0.17624 seconds