[libreoffice-users] Base knows SQL functions?

2014-11-28 Thread 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,

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

2014-11-28 Thread Luuk
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

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

2014-11-28 Thread Tom Davies
Hi :) Time for a bug-report? I think post now and then if it turns out to be not a bug you can always close it. For most people i'd hope for a bit more discussion first jic but one of the people i'd want to hear from would be you. There are quite a few people here on this mailing list who know

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

2014-11-28 Thread Mark Stanton
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. That's a good point, but not the one I was making. If I choose to change database then I would

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

2014-11-28 Thread Mark Stanton
Hi Tom, Time for a bug-report? I thought I'd just test the water here first. I've not had time to work with Base for a (very) long time now, but this might bring me back (and other situations are easing) if I'm right. Mark Stanton One small step for mankind... -- To unsubscribe e-mail