Hi Andreas,
Andreas Saeger escribió:
Hi,
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(?).
the difference is that in native sql the command goes straight to the
server without being parsed by OOo.
Of course that makes sense only when there is a[n even embedded] server
[HSQLDB embedded]: in the cases like calc, add.book, etc the driver
"acts" like a server, i.e. answers your requests.
So native SQL can make a difference when you are working when real RDBMS
(not driver-file based connections).
As an example, there was a time when OOo's parser failed to parse the
*standard* SQL string concatenator ||.
Is there any feature in "OOo SQL" not in "native SQL" for hsqldb?
AFAIK the only "feature" involved here is OOo's PARSER.
Another completely different thing are OOo's dedicated drivers:
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.
I think you are mixing two different things:
* native SQL vs. PARSER
* establish a connection with a dedicated driver vs. one with a standard
driver
In OOo Base there are dedicated drivers that supply missing
functionality in the standard drivers (example is MySQL) but it is a
different thing using native SQL or not.
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?
Sure Frank on Monday will enlighten [if this word exists in English] us
both.
Regards
Ariel.
--
Ariel Constenla-Haile
La Plata, Argentina
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.ArielConstenlaHaile.com.ar/ooo/
"Aus der Kriegsschule des Lebens
- Was mich nicht umbringt,
macht mich härter."
Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
