Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    6

    Unanswered: Paradox query reference field value in same table

    I would appreciate any help with the following Paradox 12 problem.

    I need to reference another field value in the same table in my query but don't know the syntax. To keep it simple. Say I have a table named tbl_cost.db with fields cost1 and cost2. I want my query to display only those records where cost1 is greater than cost2. The simple > cost2 in cost1 doesn't work. I have also tried numerous combinations such as below.


    | cost1
    > tbl_cost.db.cost2

    > tbl_cost.db."cost2"

    > tbl_cost.db.["cost2"]

    > tbl_cost.db.[cost2]

    > [tbl_cost.db].[cost2]

    > ([tbl_cost.db].[cost2])

    > (tbl_cost.db."cost2")

    > ([tbl_cost.db].["cost2"])

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    you have to learn how to use example elements.. same table and/or different table, same concept..

    manaually, it's the F5 key.. in code, it's the underscore.. example:

    | cost-1 | cost-2|
    | _a | > _a |
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Jul 2008
    Posts
    6
    Thank you. That was just what I needed.

Posting Permissions

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