Results 1 to 2 of 2

Thread: Displaying Data using Forms

  1. #1
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Displaying Data using Forms

    Hello friends ,

    I have to display hourwise diesel issues on a display board using forms6i as front end. If these is no issues for a particular hour i have to display value zero. But in database there will not be any record for that particular hour. So it has become compulsory for me to use join condition as follows.
    Select a.dslhours,nvl(b.qty,0)
    from
    ( select dslhours from dsl_displaytime )a
    left outer join
    ( select substr(dsl_time,1,2)dsltime,sum(nvl(dsl_stk_quantity,0))qty
    from dsl_stock_ledger
    where fillingdate = :disp_date
    and dsl_stk_tran_code = 'd_iss'
    group by substr(dsl_time,1,2) )b
    on a.dslhours = b.dsltime
    order by a.dslhours
    Is there any better way to write the query than above one from performance point of view? now how to display these twenty four hour values in forms twenty four display fields? is it compulsory to store the result of above query in another table or can we display those values directly on the form?

    Please suggest me in detail as i am new to forms.

    I am attaching required form screen shot as attachment for clarification purpose.

    Regards
    Babi

    Attached Images Attached Images Displaying Data using Forms-board-jpg 
    Last edited by babi_geek; 03-02-2008 at 12:57 AM.

  2. #2
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Re: Displaying Data using Forms

    Hi

    Could anyone helpme out this problem?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact