Frank Schönheit - Sun Microsystems Germany wrote:
If "Run SQL Direct" is off, a "SELECT * FROM query" will be translated
to "SELECT * FROM ( SELECT ... ) AS query" - but the user will not see
the latter statement (except maybe in error messages potentially thrown
by the engine), since the intention is to make the query usage
completely transparent here.
If "Run SQL Direct" is on, "SELECT * FROM query" will stay as it is, but
of course provoke an error when sent to the database.
Alright, but can I assume that as a side effect of this change a user
would now be able to enter a select->sub select statement via the SQL
view of the query builder and not have to turn 'Run SQL direct' on in
order to run the statement? ( that is of course, if there is nothing
else about the statement that would force the need for this change )
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
