Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    1

    Help Related to Database.

    Hello Everyone :P
    I need a Help..
    I'm working on a project..
    I've Databases of
    Product
    - Product ID, Product Name, Product Type
    Location
    -Location Id, City, Region, State
    Time
    -Day, Month , Year
    User
    User id, username, address, phone number.
    and a fact Table : Product ID, Location ID, User ID
    I need to create a UI using Java.. I Can do that..
    the UI will be having 4 drop downs menus of each table and the application should dynamically generate queries for
    Sales By Location
    Sales By Product
    Sales By month/day/year
    Commulative sales by year /month
    So Can anyone help me out with Dynamic query generation ?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Certainly!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

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