Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Using the HAVING clause

edited November 2001 in General
Is there a way to use the HAVING clause on a calculated field without having
to edit the sql directly.

Comments

  • edited November 2001
    Sorry, DADE doesn't support the having clause since not all databases
    support this syntax. You may want to create a backup of the DADE datamodule
    (dtm) so that you can still revert back to the way it was before you edited
    the sql and have the query tools enabled in case you want to change this
    report in the future.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.