Hi Drew, > REM the method getComposedQuery is not supported > REM > REM SingleSelectQueryCAnalyzer has instead two > REM properties: > REM > REM ElementaryQuery > REM Returns the SQL as stored > REM > REM QueryWithSubstitution > REM > REM Returns the SQL as it will be > REM sent to the database engine
not to forget "Query", which will return what you previously set as "Query", plus any filters/orders/havings/groupings you set. The difference between ElementaryQuery and Query is as follows: composer.Query = "SELECT * FROM table WHERE field = value" MsgBox composer.Filter ' => "field = value" composer.ElementaryQuery = "SELECT * FROM table WHERE field = value" MsgBox composer.Filter ' => <empty string> Analogous for the other composer attributes which reflect the ORDER BY, GROUP BY, HAVING clauses. QueryWithSubstitution is, as you said, the complete "low level" SQL statement, including any escape processing done, and resolved queries in queries. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
