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

> 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 of course have to change any product specific 
funtionality but

> If you are using Base, you can use function in Base, no mather what 
> database you attach to it.

Ok, having tested a bit further, it in fact seems to be my problem. A 
difference between the documentation I was looking at and the version of 
MaraDb on my machine.

So, to explain it fully, the (very prety and worthwhile) design mode *does* 
appear to have "a list" of what it knows about... Perhaps it has to... Even 
with that switched off Base still checks and only accepts code it knows 
about, but pressing the "SQL" button puts it into passthrough mode and it 
*doesn't* check (hurrah!). I think I should've know all that before :-(

If course if, like me, you use stuff your database server doesn't recognise 
it still won't work :-(

The way to check is to put the query into the server "directly" through its 
own console, or something like phpMyAdmin if you're also running a 
webserver.

Regards
Mark Stanton
One small step for mankind...



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