4D methods can be called inside SQL code using the following syntax:

{fn 4DFunctionName AS 4DFunctionResultType}

One thing to note, is when calling a 4D method within SQL code, the security option "Available through SQL" must be enabled. This can be done via the method properties as shown:



If the property "Available through SQL" is not checked, the error "Failed to calculate 4D function call" will be generated upon execution of the SQL code that contains the 4D function call.