Re: [libreoffice-users] SQL statement in Base query

On 07/24/2012 01:39 PM, Mark Stanton wrote:
> In article <500EA6E8.4030104@gmail.com>, 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
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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