How to use Firebird 2.1 > ABS in Firebird 2.0?

Asked

Viewed 76 times

0

I have a client who already has a system that runs on Firebird 2.0 and my system runs on the newest version of Firebird, with this I had to regress the database and has some functions that 2.0 does not have yet... How could I make ABS(pick absolute number) in Firebird 2.0?

sql database firebird firebase-database

2 answers

2


You can use the DLL's of the default installation folder of Firebird:

DECLARE EXTERNAL FUNCTION abs 
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';

0

Creating a UDF External is possible to use this Function. Build the same method in Delphi or C++ and create a dll.

Browser other questions tagged sql database firebird firebase-database

You are not signed in. Login or sign up in order to post.