FreeAdhocUDF for InterBase and FireBird in deutschin englishen français
homeprevious pageÜbersicht • overview • aperçunext pagelast page mailing-listwas ich vermisse • what I missed •eMail Kommentar • eMail commentprint
 

Functions enclosed in FreeAdhocUDF.dll/.so/.dylib :
Diverse functions 10 functions

diverse functions 4 functions

NVL-functions 6 functions

since InterBase 2007 this function is substitutable with a native SQL statem.

since FireBird 2.0 this function is substitutable with a native SQL statement

since FireBird 2.1 this function is substitutable with a native SQL statement


Output RETURN mechanism if nothing other is published: FREE_IT
TestSQLs with NULL run only in FireBird 2.0
 
Diverse functions
from substitutable with CASE
from substitutable with IIF
from substitutable with DECODE
F_IF function from adhoc
Entrypoint aif compatible with UTF-8
Input CSTRING(32) CSTRING(8) CSTRING(32) CSTRING(8190) CSTRING(8190) Comparisonstring 1
Comparisonoperator
Comparisonstring 2
if comparison applies, then result = Parameter 4
if comparison does not apply, then result = Parameter 5
Output CSTRING(8190) s.o.
"reproduction" of a IF-loop
Comparisonoperator
        =
        <>
        <
        >
        <=
        >=
        Everyone of these operators a "n" (numeric) can be placed in front, if the two comparede strings contain floatingpoint, e.g. n =
TestSQL
SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('Test', '<=', 'Testa', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE;
SELECT 'Parameter 1 ist größer' AS ISCORRECT, F_IF('Testb', '<=', 'Testa', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE;
SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('Test1', 'n<=', 'Test2', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE;
SELECT 'Parameter 1 ist kleiner' AS ISCORRECT, F_IF('123.45', 'n<=', '234.56', 'Parameter 1 ist kleiner', 'Parameter 1 ist größer') FROM RDB$DATABASE;
SELECT NULL AS ISCORRECT, F_IF(NULL, NULL, NULL, NULL, NULL) FROM RDB$DATABASE;
nach oben • go top •
F_VERSION function from adhoc
Entrypoint version compatible with UTF-8
Input without
Output CSTRING(30) version of FreeAdhocUDF
TestSQL
SELECT F_VERSION() FROM RDB$DATABASE;
F_VERSIONNAME function from adhoc
Entrypoint versionname compatible with UTF-8
Input without
Output CSTRING(255) name of the version of FreeAdhocUDF
TestSQL
SELECT F_VERSIONNAME() FROM RDB$DATABASE;
F_OSLANGUAGE function from adhoc
Entrypoint oslanguage compatible with UTF-8
Input without
Output CSTRING(30) language of the operationg system
TestSQL
SELECT F_OSLANGUAGE() FROM RDB$DATABASE;

NVL functions
These functions doesn't run in InterBase and FireBird 1.x
F_SNVL function from adhoc
Entrypoint snvl compatible with UTF-8
Input CSTRING(32760)
CSTRING(32760)
value to check if NULL
return instead of NULL
Output CSTRING(32760) value
version for strings
F_SNVL2 function from adhoc
Entrypoint snvl2 compatible with UTF-8
Input CSTRING(32760)
CSTRING(32760)
CSTRING(32760)
value to check if NULL
return instead of NULL
return instead of param 1
Output CSTRING(32760) value
version for strings with set value for not NULL
F_INVL function from adhoc
Entrypoint invl compatible with UTF-8
Input INTEGER
INTEGER
value to check if NULL
return instead of NULL
Output INTEGER value
version for integer
F_INVL2 function from adhoc
Entrypoint invl2 compatible with UTF-8
Input INTEGER
INTEGER
INTEGER
value to check if NULL
return instead of NULL
return instead of param 1
Output INTEGER value
version for integer with set value for not NULL
F_DNVL function from adhoc
Entrypoint dnvl2 compatible with UTF-8
Input DOUBLE
DOUBLE
value to check if NULL
return instead of NULL
Output DOUBLE value
version for double precision
F_DNVL2 function from adhoc
Entrypoint dnvl2 compatible with UTF-8
Input DOUBLE
DOUBLE
DOUBLE
value to check if NULL
return instead of NULL
return instead of param 1
Output DOUBLE value
version for double precision with set value for not NULL
All Functions like Oracle-NVL-functions.
TestSQL
SELECT 'is NULL' AS ISCORRECT, F_SNVL(NULL, 'is NULL') FROM RDB$DATABASE;
SELECT 'this is not NULL' AS ISCORRECT, F_SNVL('this is not NULL', 'is NULL') FROM RDB$DATABASE;
SELECT 'is NULL' AS ISCORRECT, F_SNVL2(NULL, 'not NULL', 'is NULL') FROM RDB$DATABASE;
SELECT 'not NULL' AS ISCORRECT, F_SNVL2('this is not NULL', 'not NULL', 'is NULL') FROM RDB$DATABASE;
SELECT 9999 AS ISCORRECT, F_INVL(NULL, 9999) FROM RDB$DATABASE;
SELECT 3 AS ISCORRECT, F_INVL(3, 999) FROM RDB$DATABASE;
SELECT 9999 AS ISCORRECT, F_INVL2(NULL, 999, 9999) FROM RDB$DATABASE;
SELECT 123 AS ISCORRECT, F_INVL2(3, 123, 9999) FROM RDB$DATABASE;
SELECT 0.0001 AS ISCORRECT, F_DNVL(NULL, 0.0001) FROM RDB$DATABASE;
SELECT 3.0 AS ISCORRECT, F_DNVL(3.0, 0.0001) FROM RDB$DATABASE;
SELECT 0.0001 AS ISCORRECT, F_DNVL2(NULL, 3.333, 0.0001) FROM RDB$DATABASE;
SELECT 3.333 AS ISCORRECT, F_DNVL2(3.0, 3.333, 0.0001) FROM RDB$DATABASE;
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site