Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 17065, Building UDF Libraries

by Craig Stuntz Email: Anonymous


This article is both a quick introduction to writing simple User Defined Functions (UDFs) for InterBase and a fairly complete reference guide to UDF programming techniques.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For InterBase, Version 5.6  to 6.5 1816 downloads
Copyright: All rights reserved


Size: 83,609 bytes
Updated on Thu, 15 Nov 2001 09:50:00 GMT
Originally uploaded on Thu, 15 Nov 2001 09:51:05 GMT
SHA1 Hash: 157AC9E182331C0522E59CE710860D05451860E2
MD5 Hash: 955D30C4C87610857C480B72BB3B6044

    Explore the files in this upload

Description
This article is both a quick introduction to writing simple User Defined Functions (UDFs) for InterBase and a fairly complete reference guide to UDF programming techniques. Accordingly, it is divided into two sections.

In the first section, the reader will learn how to quickly create simple UDFs in Delphi. Since UDFs, in general, should be simple, this section may be all that is necessary for most InterBase users. In the second section, we’ll explore the reasons behind the suggestions in the first section.

What is a UDF? A user defined function (UDF) in InterBase is merely a function written in any programming language that is compiled into a shared library. Under Windows platforms, shared libraries are commonly referred to as dynamic link libraries (DLL's). This simple use of shared libraries provides the developer with a large amount of power and flexibility. Virtually any function that can be exposed through a DLL can be used by InterBase. This comment, however, should be taken with a grain of salt — the intent of a UDF is to perform some small operation that is not available in SQL or InterBase’s stored procedure language.

An example of a UDF is

function Modulo (Numerator, Denominator: Integer): Integer

Divide Numerator by Denominator and return the remainder.

This function is essential in many routines, but it is not available in InterBase’s DSQL language.

For more information, see http://delphi.weblogs.com

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03