Скачать или смотреть Writing Interbase UDFs in Delphi

In this video, I demonstrate how to get started with UDFs for Interbase. UDFs are "User-Defined Functions", which are similar to Stored Procedures. The difference is that they are not programmed in SQL, but are coded in external DLL, which will then be loaded by Interbase.
I am not a big fan of stored procedures when it comes down to business logic. UDFs though have a clear focus on "functions", that means you can write string, date and other math logic with the tool of your choice - which is Delphi in my case - and then uses these functions as if they were part of the SQL language.

I will show how to use Unicode/UTF8 with your UDFs, which is a little bit tricky.

Sample code can be found here:
https://bitbucket.org/omonien/publicd...