Advantage DB & Query Builder

rbuser

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.

nardmoseley

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

rbuser

Rock-n-Roll,
Thanks Nard.