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

Advantage DB & Query Builder

edited February 2003 in End User
Using Advantage as the backend of a system where the end-user reporting tool
is delivered as a feature, I have a concern.
I do know that Advantage only supports a subset of the ANSI standard for
SQL. This includes not handling subqueries well if at all. I am concerned
with what this will mean with our end-user reporting tool and the Query
Builder. Will our end-users find that they can put together a query using
Query Builder which produces SQL that is more than Advantage can handle?
Should I be concerned?

Thanks in advance.

Comments

  • edited February 2003

    This is not an issue. The RB query tools do not support subqueries. The
    Query tools will not build invalid SQL that Avantage cannot process. The
    only way the end-users could do this, is if they manually edit the SQL
    string. As a developer you can control whether the end-users are allowed to
    manually edit the SQL, but setting the value of
    TppDesigner.DataSettings.AllowEditSQL

    The Query Designer always validates the SQL prior to saving the query.
    Therefore if you were to type in a SQL statement that is not valid, you
    would receive an error message and would not be able to close the query
    designer until you correct it.



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2003
    Rock-n-Roll,
    Thanks Nard.


This discussion has been closed.