OraFAQ Forum: Forms » LOV (merged 3) forms 6i ,window 2003 server

Home » Developer & Programmer » Forms » LOV (merged 3) forms 6i ,window 2003 server

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

LOV (merged 3) forms 6i ,window 2003 server [message #416746]

Tue, 04 August 2009 03:30

kilimanjaro
Messages: 151
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 .

Report message to a moderator

Re: LOV [message #416748 is a reply to message #416746]

Tue, 04 August 2009 03:39

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: LOV [message #416751 is a reply to message #416746]

Tue, 04 August 2009 03:58

azamkhan
Messages: 557
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

Report message to a moderator

Re: LOV (merged 3) forms 6i ,window 2003 server [message #416800 is a reply to message #416746]

Tue, 04 August 2009 06:00

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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.

Report message to a moderator

Re: LOV [message #416840 is a reply to message #416748]

Tue, 04 August 2009 12:33

kilimanjaro
Messages: 151
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).

Report message to a moderator

Re: LOV [message #416854 is a reply to message #416840]

Tue, 04 August 2009 15:00

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: LOV [message #416923 is a reply to message #416854]

Wed, 05 August 2009 03:23

kilimanjaro
Messages: 151
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.

Report message to a moderator

Previous Topic:	picture / Image Displaying using bfile data type
Next Topic:	Icon on Selected Node

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:49:14 CDT 2024