building view help
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: building view help

  1. #1
    Join Date
    Aug 2001
    Posts
    87

    building view help

    Hi,

    I have table having the following

    acc_name , date , debit ,credit

    i need to build view as the following

    acc_name , date , prev_balance,debit,credit,acc_balance

    looking for your help

    regards

  2. #2
    Join Date
    Aug 2001
    Posts
    87
    i have to do that urgent pls help me

  3. #3
    Join Date
    Sep 2006
    Posts
    5
    Hi,

    I don't understand exactly what's the problem?
    For example, what is the meaning of prev_balance and acc_balance?

  4. #4
    Join Date
    Aug 2001
    Posts
    87
    Hi jvalerof,

    thanks for your reply

    prev_balance = previous balance before the accounting date
    acc_balance = accumulative balance

    hope it is clear

  5. #5
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    If you want to know what the syntax of a "create view" statement is, then you ought to know that and I don't think anyone on this forum will help you with anything so basic.

    If you have a specific problem with creating the view e.g. there is some complex processing you want to do in it, then we may be able to help you. You will need to give more details on what the view is doing and why you are having a problem creating it.

  6. #6
    Join Date
    Aug 2001
    Posts
    87
    acc_name date prev_bal debit credit acc_balance
    XZ 01/01/06 1000 100 0 1100
    02/01/06 1100 0 1000 100

    this example of what i look for in my view

    regards for all

  7. #7
    Join Date
    Sep 2006
    Posts
    5
    Hi hsdbda,

    for what I see:

    acc_balance = prev_bal + debit - credit

    is that right?

    But, how do you calculate prev_bal?

  8. #8
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    The question cannot be answered on the basis of the information you have given. We will need to know:

    a) what tables the view based on and how they join together
    b) which columns in the table(s) are required in the view and whether they are named differently in the view
    c) any special processing that needs to take place

  9. #9
    Join Date
    Aug 2001
    Posts
    87
    very simple

    one table same fields as mentioned above

    reagrds

  10. #10
    Join Date
    Aug 2001
    Posts
    87
    where are the experts

    is it too cmplicated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width