FreeAdhocUDF for InterBase and FireBird in deutschin englishen françaisen españolin italianoa português
homeprevious pageÜbersicht • overview • aperçunext pagelast page Seite empfehlen • advice website •Umfrage • poll • sondage mailing-listwas ich vermisse • what I missed •eMail Kommentar • eMail commentprintsitemap
Diverse functions 2 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
F_IF function from adhoc
substitutable with CASE
substitutable with IIF
substitutable with DECODE
Entrypoint aif
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
Input without
Output CSTRING(254) version of FreeAdhocUDF
TestSQL
SELECT F_VERSION() FROM RDB$DATABASE;
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site