Re: [libreoffice-users] Base knows SQL functions?

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: users+unsubscribe@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