Calling 4D project methods from SQL statements allows developers to use 4D code that already works to improve their searches. This option does not alter the structure of the SQL statement and any project method can be called from within SQL. In this way developers can have the benefit of reusing 4D code from within a SQL statement to perform more complex tasks. Developers more familiar with SQL can implement the functionality of the 4D language without worrying about syntax details so long as they understand the method’s input and expected output.
Download Complete Tech Note and example: Windows | Mac