On 28-11-2014 10:03, Mark Stanton wrote:
It seems that Base has a list of keywords and functions for SQL, is
that right?
On the one hand it might be a good thing, on the other, unless the
list is kept up to date then it's a real pain.
For example, "ADD_DATE" (or DATEADD) in MariaDb, doesn't seem to be on
its list. That means that, even though it's perfectly acceptable SQL
for the backend, and even though Base does no querying itself, it
won't pass on a query with this function in it. There are (many)
other examples.
Any thoughts?
Mark Stanton
One small step for mankind...
If you are using Base, you can use function in Base, no mather what
database you attach to it.
If you decide to use function(s) that are database specific, you tie the
application you are creating to that database. It will no longer be
functional if yout switch from i.e. MariaDB to MSSQL.
--
To unsubscribe 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
