Hi Andreas,
> I prefer to create selects in SQL view. In SQL view I have can turn on
> "native SQL" which is the same as "pass-through" in Access(?).
> Is there any feature in "OOo SQL" not in "native SQL" for hsqldb? The
> only scenario I can think of is a minimalistic j/odbc driver where the
> functions specified in
> http://dba.openoffice.org/specifications/file_based_functions.html are
> missing.
Without native SQL, Base will not only parse, but also touch the
statement, and kind of "normalize" it. There's a number of features you
have only access to if Base's parser is involved. For instance, for
backends which do not support named parameters ("WHERE <field> =
:param"), you can still use named parameters in the UI (which is more
convenient), and Base will translate them before sending them to the
server. More features from this category queries in queries, or
translating different date/time formats in the SQL statement.
> When using sdbc drivers for spreadsheet/text/dBase/LDAP/address books
> there is no difference between both modes since native SQL passes
> through to the same driver that would be used anyways, right?
That's true. The "backend" for the mentioned types is completely
implemented as part of Base, thus it uses the very same parser. So even
if you switch native SQL on, this only means the "frontend part" of Base
does not touch the statement. The drivers themselves still use the
parser to analyze the SQL.
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]
