Hi Andrew, >>>2) The user at this point turns 'Run SQL Direct' on. Now what must >>>happen? >> >>Nothing. I think any magic applied when toggling the button will fail in >>50% of all cases (as it's the usual crux with magic :). Not to mention >>that it becomes arbitrarly complex when switching back, as you outlined. > > How then would the user retrieve the actual SQL statement that would be > sent to the engine, or is that no longer available?
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. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
