KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: "Failed to calculate 4D function call" Error when Calling 4D Methods in SQL Code
PRODUCT: 4D | VERSION: 12 | PLATFORM: Mac & Win
Published On: January 31, 2012
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.