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

Am 28.11.2014 um 10:03 schrieb Mark Stanton:
> 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...

A list of functions that should work with all types of database
connections because they are built into Base:
> http://www.openoffice.org/dba/specifications/file_based_functions.html

Functions of the embedded HSQLDB 1.8:
> http://www.hsqldb.org/doc/1.8/guide/ch09.html#stored-section

Anything beyond depends on your connected database engine.



-- 
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