Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    Unanswered: please help with this query in paradox

    would anyone please help me to translate this query to sql. thank in advance
    report10 | LMS_DRG |COUNT |WEIGHT
    |_a |_b |_c
    report |DRG |Reassignment |Reasignment_Weight
    |_a |_d, changeTo _b+_d |_e, Changeto ((-1)*_c)+_e

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    En Anglais, s'il vous plait? In other words: can you rephrase your question in English?

    -PatP

  3. #3
    Join Date
    Aug 2006
    Posts
    3
    pat, if i know how to rephrase that paradox query in english, I would already know how to convert to sql. I just don't understand what that query mean.

  4. #4
    Join Date
    Nov 2006
    Posts
    34
    select LMDS_DRG, count, weigth
    from table report10
    then it shoud be a code for a formula reasigning somme atributes betwen them in the data iff i'm not wrog,
    iff i'm sorry
    report |DRG |Reassignment |Reasignment_Weight
    |_a |_d, changeTo _b+_d |_e, Changeto ((-1)*_c)+_e
    the bold words are comandlines and the Reassignment it shoud be final table

    Lehel

  5. #5
    Join Date
    Aug 2005
    Posts
    1
    the _ indicates a field that the data field to be used in a calculation. The words in the first line are names of fields in a Paradox table. Therefore _a would refer to the report field in the table.

Posting Permissions

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