For forums, blogs and more please visit our
Developer Tools Community.
By: Borland Staff
Abstract: One external function may be declared at a time in the SQL editor
How do I declare an InterBase UDF with the Database Desktop?
This document applies to InterBase versions 4.0 and up.
In Database Desktop, you can enter SQL statements directly with the
SQL editor. There are two ways to access the SQL editor. You can either
click on the SQL icon on the toolbar, or select File | New | SQL File to
access the SQL editor. After entering an SQL statement with the SQL editor,
you still will need to commit them. The statement to declare the UDF's need only
be issued once to make the functions permanently available in your database.
You can only declare one external function at a time. Here are a couple of
examples using functions from the supplied ib_udf.dll:
declare external function strlen
returns integer by value
declare external function substr
cstring(80), smallint, smallint
returns cstring(80) free_it
If you have several functions to declare, or want to declare a whole
library, you are better to put them all in a script and execute that script
using WISQL, or another tool that allows you to process scripts.
(You can't process scripts in Database Desktop).
source : Helen Borrie
from the list server
Could not retrieve comments. Please try again later.
Free Developer Edition!
Click here to download a free non-expiring Developer Edition or 30-day trial >
More InterBase Info
InterBase XE7 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase on Twitter
Server Response from: ETNASC01