NexusDB

We call the feature "SQL extension scripting" and it allows you to dynamically create, load and use functions for use in normal NexusDB SQL.

As usual, let's start with an

Example

First we create a script file called sqlExtensionTest.nxscript:

The "magic" in this script is the predefined RegisterSQLFunctions function. When the script gets loaded by the server, this function is executed. The function can register any number of named functions into the SQL engine by simply adding them to the RegisteredSQLFunctions list. The function is defined by passing an instance of a simple TnxSQLFunctionInfo class. It's constructor looks like this:

aReturnType at this point in time needs to be rttAsArg1x meaning the function returns one variant argument. It is (just like aExample and aSyntax) included for future extensions, specifically for returning cursors. aArgCount is obviously the number of arguments that the function takes and aFunctionName is clear anyways.

Once the function is registered all you need to do is to implement the function, so we simply create a pascal function called aFunctionName with the matching arguments and return type variant. That's all there is to it.

How to use it???

Very simple actually. First step is to place the file into a SQLScripts subdirectory of the server (this will obviously be customizable in the release version via a server setting). Then we need to load the script from SQL and call the functions. It goes like this: