035179593513 [email protected]
Mysql function sys_eval does not exists

Mysql function sys_eval does not exists

To install and enable the sys calls in MariaDB and Mysql with newer Versions you have to copy a plugin into the mysql plugin folder: On a Linux Server copy the plugin in the mysql plugin directory /usr/lib/mysql/plugin/lib_mysqludf_sys.so and install it on a mysql...

SQL extend a Recordset / VBA DAO etc.

Sometimes you will get a problem if you want to add a data entry to a recordset, it can be done without the need of inserting the data entry to the table. It is a little bit tricky but with a union statement you can do following: your normal statement looks like:...