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