On 07/24/2012 01:39 PM, Mark Stanton wrote:
In article <[email protected]>, Jay Lozier wrote:
Actually most users of different backend db will be familiar with the
SQL version of that backend. What users need are two things: a connector
between Base and the backend and instructions on connecting to that backend.
The problem is, I think, that Base does some "pre-processing" to check the SQL,
which
causes a problem, particularly in this context (non-standard SQL). Although
there are
some helpful points to it are there enough?
Regards
Mark
Another question is whether a generic connector versus a specific
connector (say for MySQL) will more problematic. I would hope a specific
connector would address using some of the extensions which a generic
connector probably would not. Also, I would expect Base to lag behind
the current release of most backends. New features in the current
release may not be supported by Base or the connector. The severity of
this issue probably depends on whether the db project/vendor explicitly
supports using Base as a front end or are they supplied by others
(independent or AOO/LO).
I prefer to use Base for entry forms and predefined queries and use
other db specific tools for administrative tasks and db design.
--
Jay Lozier
[email protected]
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted