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