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 •Forum mailing-listwas ich vermisse • what I missed •eMail Kommentar • eMail commentprintsitemap
Versions of FreeAdhocUDF
   adhoc 20101206 from 2010-12-06  (St.Nicholas edition)
   adhoc 20101111 from 2010-11-11 (carnival edition)
   adhoc 20090925 from 2009-09-25
   adhoc 20090128 from 2009-01-28
   adhoc 20080303 from 2008-03-03
   adhoc 20080219 from 2008-02-19
   adhoc 20071203 from 2007-12-03
   adhoc 20071128 from 2007-11-28
   adhoc 20070824 from 2007-08-24
   adhoc 20070823 from 2007-08-23
   adhoc 20070809 from 2007-08-09
   adhoc 20070209 from 2007-02-09
   adhoc 20061221 from 2006-12-21
   adhoc 20061031 from 2006-10-31
   adhoc 20060925 from 2006-09-25
   adhoc 20060516 from 2006-05-16
   adhoc 20060509 from 2006-05-09
   adhoc 20060306 from 2006-03-06
   adhoc 20060302 from 2006-03-02
   adhoc 20051231 from 2005-12-31
   adhoc 20051016 from 2005-10-16
  1st Version (without versions-No.) from 2004-08-23 
Version "adhoc 20101206" versionname "St.Nicholas edition" from 2010-12-06
4 fixed functions
Fixed bug in
- F_INTOSTR for NULL-Input
- F_INDMINUTESBETWEENTHR for NULL-Input
- F_UUIDVERSION (check of legal Input)
- F_KW2PS (wrong formula)
1 changed function
- F_VERSION (now limit of  max. 30 Characters)
2 enhanced functions (raise of exactness
)
- F_E
- F_PI
16 new functions
- F_C_KMPL2L100KM
- F_C_L100KM2KMPL
- F_C_MPL2L100KM
- F_C_L100KM2MPL
- U_MONTHLONGLANG
- U_MONTHSHORTLANG
- U_DOWLONGLANG
- U_DOWSHORTLANG
- U_NBSP
- U_NNBSP
- F_VERSIONNAME
- F_OSLANGUAGE
- F_EPSILON
- F_TZVALUETOUTC (shows the diff of local time to UTC in hours)
- F_LOCAL2UTC (converts the local server time to UTC)
- F_UTC2LOCAL (converts UTC to the local server time)
fixed wrong entrypoint in declair-script for
- F_C_L100KM2MPGBGAL
- F_C_L100KM2MPUSGAL
- F_C_MPGBGAL2L100KM
- F_C_MPUSGAL2L100KM
update manual
remade DECLARE-scripts
new and fixed functions tested with:
- FireBird 1.5.6 Windows2000 Advanced Server SP4
    - FreeAdhocUDF_FB15x_i32_MSVC9.dll
- FireBird 1.5.6 ubuntu 6.06.2 LTS Desktop
    - FreeAdhocUDF_FB15x_i32_glibC23.so
- FireBird 1.5.6 SUSE  10.0
    - FreeAdhocUDF_FB15x_i32_glibC23.so
- FireBird 1.5.6 ubuntu 8.04.4 LTS Server
    - FreeAdhocUDF_FB15x_i32.so
this will be our last version of FreeAdhocUDF for FireBird 1.5
- FireBird 2.1.3 Windows XP SP2
     - FreeAdhocUDF_FB2x_i32_MSVC9.dll
     - FreeAdhocUDF_FB2x_i32_oWatC.dll
- FireBird 2.1.3 ubuntu 8.04.4 LTS Desktop
    - FreeAdhocUDF_FB2x_i32.so
- FireBird 2.5.0 Windows XP SP2
     - FreeAdhocUDF_FB2x_i32_MSVC9.dll
     - FreeAdhocUDF_FB2x_i32_oWatC.dll
- FireBird 2.5.0 Windows7 32bit
     - FreeAdhocUDF_FB2x_i32_MSVC9.dll
- FireBird 2.5.0_amd64 Windows7 64bit
     - FreeAdhocUDF_FB2x_i64_MSVC9.dll
- FireBird 2.5.0 ubuntu 10.04.1 LTS Server
    - FreeAdhocUDF_FB2x_i32.so
- FireBird 2.5.0_amd64 ubuntu64 10.04.1 LTS Server
    - FreeAdhocUDF_FB2x_amd64.so
- InterBase 7.5.1 Windows XP SP2
    - FreeAdhocUDF_IB_i32_MSVC9.dll
- InterBase 7.5.1 ubuntu 8.04.4 LTS Server
    - FreeAdhocUDF_IB_i32.so
- InterBase XE32 Windows7_32
     - FreeAdhocUDF_IB_i32_MSVC9.dll
- InterBase XE64 Windows7_64
     - FreeAdhocUDF_IB_i64_MSVC9.dll
nach oben • go top •
Version "adhoc20101111 carnival edition" from 2010-11-11
18 fixed functions
fixed bug in
- F_REPLACESTRING / U_REPLACESTRING / F_BLOBREPLACESTRING / U_BLOBREPLACESTRING
- F_SOUNDEX
- F_BLOBLINE
- F_BLOBTEXTPOS
- F_FIRSTDAYKW, F_LASTDAYKW, F_FIRSTDAYWOY, F_LASTDAYWOY if 1.1. is a Friday (i.e. 2010)
- F_REPLACE
- F_FIXEDPOINTLANG
in openWatcomC-versions in
- F_DZERO
- F_Z
- F_PI
- F_E
- F_C
- F_G
- F_K
- Attention! for F_DZERO, F_Z and all constant-functions CHANGED Declair-Scripts! (rund Update!)
for some numbers in
- F_ROUNDTOEVEN
- F_SOFTROUND
10 improved/enhanced funtions
replaced "dirty workaround" with Epsilonics and
possibility for input negativ rounding-digits
- F_ZAHLRUNDEN
- F_ROUNDCOMMON
- F_FIXEDPOINTLANG
- F_ROUNTOEVEN
- F_SOFTROUND
remake of compatibility to FreeUDFLib and FreeUDFLibC (used local settings for language not allways english)
- F_CMONTHLONG
- F_CMONTHSHORT
- F_CDOWLONG
- F_CDOWSHORT
check of legal output
- F_UUIDVERSION
switched to icu 4.4.2 (from 3.0) for UNICODE
please attend to the page "necessary additional files"
11 new functions
- F_DSQM
UTF8-versions of F_CMONTLONG etc.
- U_MONTHLONG
- U_MONTHSHORT
- U_DOWLONG
- U_DOWSHORT
- U_DATE2STRLANG
- U_MONTHLONGLANG
- U_MONTHSHORTLANG
- U_DOWLONGLANG
- U_DOWSHORTLANG
to complet all variants of rounding
- F_RAPPENRUNDUNG
update manual
remade main DECLARE-scripts

new and fixed functions tested with:
- InterBase 7.5.1 on ubuntu 8.04.3 LTS Server
    - used FreeAdhocUDF_IB_i32.so
    - FAUfile.so DOESNOT run
- InterBase 2009 on ubuntu 10.04 LTS Desktop
    - used FreeAdhocUDF_IB_i32.so, FAUfile_IB_i32.so
- InterBase XE32 on Windows XPSP2
     - used FreeAdhocUDF_IB_i32_MSVC9.dll, FAUfile_IB_i32_MSVC9.dll
- InterBase XE32 on Windows7_32
     - used FreeAdhocUDF_IB_i32_MSVC9.dll, FAUfile_IB_i32_MSVC9.dll
- InterBase XE64 on Windows7_64
     - used FreeAdhocUDF_IB_i64_MSVC9.dll, FAUfile_IB_i64_MSVC9.dll
- FireBird 1.5.6 on Windows2000 Advanced Server SP4
    - used FreeAdhocUDF_FB15x_i32_MSVC9.dll, FAUfile_FB15x_i32_MSVC9.dll
- FireBird 1.5.6 on ubuntu 6.06.2 LTS Desktop
    - used FreeAdhocUDF_FB15x_i32_glibC23.so, FAUfile_FB15x_i32.so
- FireBird 1.5.6 on SUSE  10.0
    - used FreeAdhocUDF_FB15x_i32_glibC23.so, FAUfile_FB15x_i32.so
- FireBird 2.0.3 on Eisfair base 1.7.1 eiskernel 1.14.1 (2.4.35-wt1)
    - used FreeAdhocUDF_FB2x_i32_eisfair1.so, FAUfile_FB2x_i32_eisfair1.so
- FireBird 2.1.3 on WindowsXP SP2
    - used FreeAdhocUDF_FB2x_i32_MSVC9.dll, FAUfile_FB2x_i32_MSVC9.dll
- FireBird 2.1.3 on openSuse 11.1
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.1.3 on ubuntu 8.04.3 LTS Server
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.1.3 amd64 on ubuntu64 9.04 Server
    - used FreeAdhocUDF_FB2x_amd64.so, FAUfile_FB2x_amd64.so
- FireBird 2.5.0 on Windows XP SP2
     - used FreeAdhocUDF_FB2x_i32_MSVC9.dll, FAUfile_FB2x_i32_MSVC9.dll
- FireBird 2.5.0 on ubuntu 10.04.1 LTS Desktop
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.5.0 amd64 on ubuntu64 10.04.1 LTS Desktop
    - used FreeAdhocUDF_FB2x_amd64.so, FAUfile_FB2x_amd64.so
Version "adhoc20090925" from 2009-09-25
fixed functions
fixed bug in
- F_ENCRYPTMD5
- F_STRCOPY
- F_PRED and F_SUCC (functions had been swaped because of their names)
- F_ZAHLRUNDEN / F_ROUNDCOMMON
- all UUID-functions (memory-problem)
no check of legal values in input-paramters in
- F_CONVERTTOBASE
now only complete years and month are count (exactly to seconds)
- F_AGEINYEARS (F_AGEINYEARSN, F_AGEINYEARSTHRESHOLD, F_AGEINYEARSTHRESHOLDN)
- F_AGEINMONTHS(F_AGEINMONTHSN, F_AGEINMONTHSTHRESHOLD, F_AGEINMONTHSTHRESHOLDN)
16 new date-functions
- F_FIRSTDAYLASTQUARTER
- F_LASTDAYLASTQUARTER
- F_FIRSTDAYNEXTQUARTER
- F_LASTDAYNEXTQUARTER
- F_FIRSTDAYLASTMONTH
- F_LASTDAYLASTMONTH
- F_FIRSTDAYNEXTMONTH
- F_LASTDAYNEXTMONTH
- F_FIRSTDAYLASTWEEK
- F_LASTDAYLASTWEEK
- F_FIRSTDAYLASTWEEKISO
- F_LASTDAYLASTWEEKISO
- F_FIRSTDAYNEXTWEEK
- F_LASTDAYNEXTWEEK
- F_FIRSTDAYNEXTWEEKISO
- F_LASTDAYNEXTWEEKISO
1 new numeric funktion
- F_INPUTVAL
29 new UTF-8 qualified funktions (UTF-8 versions of existing ISO-funktions)
- U_LEFT
- U_RIGHT
- U_MID
- U_PADLEFT
- U_PADRIGHT
- U_PADCENTER
- U_SUBSTR,
- U_STRRM,
- U_REPLACESTRING,
- U_REVERSE,
- U_STRIPSTRING,
- U_STRIPSTRINGHOLD,
- U_REPEATTRIM,
- U_STRSTUFF,
- U_PREDECESSOR,
- U_SUCCESSOR,
- U_LOWER,
- U_UPPER,
- U_PROPERCASE,
- U_CHARACTER,
- U_ORD,
- U_RSTRCMP,
- U_STRINGLENGTH,
- U_CYRILLIC_LATIN,
- U_LINEWRAP,
- U_CONVERTSYMBOLS,
- U_FINDWORD,
- U_BLOBREPLACESTRING,
- U_BLOBSUBSTR
New (separate) UDF FAUfile
1 BLOb-file-funktion moved from FreeAdhocUDF
- F_BLOBLOAD - load (binary)file from filestem to BLOb
2 new BLOb-file-funktions
- F_FILEVERSION
- F_BLOBSAVE - saves (binary)file from a BLOb to filesystem
The Windows versions now contains a version-info (right-click on properities inside explorer)
InterBase until 7.1 and FireBird 1.0 is no longer official supported  - we must compile additional versions for them
update manual
remade all DECLARE-scripts

new and fixed functions tested with:
- InterBase 7.5.1 on ubuntu 8.04.3 LTS Server
    - used FreeAdhocUDF_IB_i32.so
    - FAUfile.so DOESN'T run
- InterBase 2009 on Windows XPSP2
     - used FreeAdhocUDF_IB_i32_oWatC.dll, FAUfile_IB_i32_oWatC.dll
         - needed in .../interbase/bin
                   - icudt30.dll
                   - icuuc30.dll
- InterBase 2009 on ubuntu 8.04.3 LTS Desktop
    - used FreeAdhocUDF_IB_i32.so, FAUfile_IB_i32.so
         - needed libstdc++5
         - needed in .../interbase/lib
                 - libicudata.so.30.0
                 - libicuuc.so.30.0
                 and symbolic links:
                 ln -s libicudata.so.30.0 libicudata.so.30
                 ln -s libicudata.so.30.0 libicudata.so
                 ln -s libicuuc.so.30.0 libicuuc.so.30
                 ln -s libicuuc.so.30.0 libicuuc.so
- FireBird 1.5.5 on Windows2000 Advanced Server SP4
    - used FreeAdhocUDF_FB15x_i32_oWatC.dll, FAUfile_FB15x_i32_oWatC.dll
- FireBird 1.5.5 on MandrivaLinux 10.2 (LE 2005)
    - used FreeAdhocUDF_FB15x_i32_glibC23.so, FAUfile_FB15x_i32.so
- FireBird 1.5.5 on ubuntu 6.06.2 LTS Desktop
    - used FreeAdhocUDF_FB15x_i32_glibC23.so, FAUfile_FB15x_i32.so
- FireBird 1.5.5 on SUSE  10.0
    - used FreeAdhocUDF_FB15x_i32_glibC23.so, FAUfile_FB15x_i32.so
- FireBird 2.0.3 on Eisfair base 1.6.3 eiskernel 1.14.1 (2.4.35-wt1)
    - used FreeAdhocUDF_FB2x_i32_eisfair1.so, FAUfile_FB2x_i32_eisfair1.so
- FireBird 2.1.3 on WindowsXP SP2
    - used FreeAdhocUDF_FB2x_i32_oWatC.dll, FAUfile_FB2x_i32_oWatC.dll
    - used FreeAdhocUDF_FB2x_i32_MSVC9.dll, FAUfile_FB2x_i32_MSVC9.dll
- FireBird 2.1.3 on openSuse 11.1
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.1.3 on ubuntu 8.04.3 LTS Server
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.1.3 amd64 on ubuntu 9.04 amd64 Server
    - used FreeAdhocUDF_FB2x_amd64.so, FAUfile_FB2x_amd64.so
- FireBird 2.5.0beta2 on Windows XP SP2
     - used FreeAdhocUDF_FB2x_i32_oWatC.dll, FAUfile_FB2x_i32_oWatC.dll
     - used FreeAdhocUDF_FB2x_i32_MSVC9.dll, FAUfile_FB2x_i32_MSVC9.dll
- FireBird 2.5.0beta2 on ubuntu 8.04.3 LTS Desktop
    - used FreeAdhocUDF_FB2x_i32.so, FAUfile_FB2x_i32.so
- FireBird 2.5.0beta2 amd64 on ubuntu 8.04.3 amd64 LTS Desktop
    - used FreeAdhocUDF_FB2x_amd64.so, FAUfile_FB2x_amd64.so
Interim-versions "adhoc20090715interim" and "adhoc20090720interim"
not published test-versions - only for internal usage
nach oben • go top •
Bugfix-version "adhoc20090128a" from 2009-01-31
1 fixed function
fixed bug in:
- F_WOYISO
nach oben • go top •
Version "adhoc20090128" from 2009-01-28
4 fixed functions
fixed bug in:
- F_PROZENTE (wrong results)
- F_COUNTWEEKDAYS (wrong results in some circumstances)
- F_UUID1TIMESTAMP and UUID1COMPRTIMESTAMP now threadsave with Windows
fixed declair-Script for F_RC
All scripts are updated 2008-12-19 also for the download-version adhoc20080303
fixes wrong declarations in declair-Script declarations_rfunc.sql for
- EXTRACTDATE
- EXTRACTTIME
- FIRSTDAYMONTH
- LASTDAYMONTH
- INCDATE
- INCDATETIME
- MAXDATE
- MINDATE
- LTRIM
- LONGLTRIM
- RTRIM
- LONGRTRIM
- TRIM
- LONGTRIM
- SUBSTR
- LONGSUBSTR
- RUPPER
- LONGRUPPER
- RLOWER
- LONGRLOWER
- WORDNUM
- LONGWORDNUM
- REPEATTRIM
- LONGREPEATTRIM
All scripts are updated 2008-12-19 also for the download-version adhoc20080303
12 new converting functions
- F_C_OBU2G - Obulus (ancient world ) to Gramm
- F_C_G2OBU - Gramm to Obulus
- F_C_DRA2G - Drachme (ancient world ) to Gramm
- F_C_G2DRA - Gramm to Drachme
- F_C_GBBU2L - GB bushel to Litre
- F_C_L2GBBU - Litre to GB bushel
- F_C_USBU2L - US bushel to Litre
- F_C_L2USBU - Litre to US bushel
- F_C_TIME2DECTIME - Time to decimal-time
- F_C_DECTIME2TIME - decimal-time to time
- F_C_TIME2INDTIME- time to industrial time (seconds rounded to minutes)
- F_C_INDTIME2TIME - industrial time to time
26 new numeric functions
- F_CROSSSUM - chross sum
- F_CROSSDIFF- chross diff
- F_WEIGHTCROSSSUM - weighted cross sum
- F_ITERATECROSSSUM - iterate (or single-digit) cross sum
- F_GTIN8CHECK - GTIN-8 checkdigit
- F_GTIN8 - complete GTIN-8 number
- F_UPC12CHECK - UPC-12 checkdigit
- F_UPC12 - complete UPC-12 number
- F_GTIN13CHECK - GTIN-13 checkdigit (former EAN number)
- F_GTIN13 - complete GTIN-13/GLN number
- F_GTIN14CHECK - GTIN-14 checkdigit
- F_GTIN14 - complete GTIN-14 number
- F_NVE18CHECK - NVE-18 checkdigit
- F_NVE18 - komplete NVE-18 number
- F_ISBN10CHECK - ISBN-10 checkdigit
- F_ISBN10 - complete ISBN-10 number
- F_ISBN13CHECK - ISBN-13 checkdigit
- F_ISBN13 - complete ISBN-13 number
- F_ISSN8CHECK - ISSN checkdigit
- F_ISSN8 - complete ISSN number
- F_UPSTNCHECK -  UPS Tracking-No. checkdigit
- F_UPSTN - complete UPS Tracking-No.
- F_2OF5CHECK -  2of5 checkdigit
- F_2OF5 - complete 2of5 number
- F_CODE39CHECK - code-39 checkdigit
- F_CODE39 - complete code-39 number
16 new date/time/timestamp functions
- F_AGEINWORKINGDAYS - like F_AGEINDAYS but you can exclude one or more weekdays from calculation
- F_AGEINWORKINGDAYSTHRESHOLD - like F_AGEINDAYSTHRESHOLD but you can exclude one or more weekdays from calculation
- F_WORKINGDAYSBETWEEN - like F_DAYSBETWEEN but you can exclude one or more weekdays from calculation
- F_INDMINUTESBETWEEN - industrialminutes between two timestamps
- F_INDMINUTESBETWEENTHR -  industrialminutes between two timestamps, with min- and max-time
- F_INDMINUTESBETWEENTHRIB - InterBase-version of INDMINUTESBETWEENTHR
- F_FIRSTDAYQUARTER - first date of the quarter of the input-date
- F_LASTDAYQUARTER - last date of the quarter of the input-date
- F_FIRSTDAYWEEK - first date of the (US)week of the input-date (1st day of week = Sunday)
- F_FIRSTDAYWEEKISO - first date of the (ISO)week of the input-date (1st day of week = Monday)
- F_LASTDAYWEEK -last date of the (US)week of the input-date (last day of week = Monday)
- F_LASTDAYWEEKISO - last date of the (ISO)week of the input-date (last day of week = Sunday)
- F_FIRSTDAYWOY - first date of the (US)week of the year
- F_LASTDAYWOY - last date of the (US)week of the year
- F_FIRSTDAYKW - first date of the (ISO)week of the year
- F_LASTDAYKW - last date of the (ISO)week of the year
1 new BLOb function
- F_BLOBLOAD - loads (binary)file into a BLOb
6 new other functions
NVL-functions (NULL-value-functions) like Oracle:
These functions are running (sorry) only from FireBird 2.0 - older FireBird and all InterBase versions are not able to return NULL!
The
Microsoft VisualC 8 (msvc8) builds no longer needs linked libraries during runtime (i. e. VC80.CRT)
- F_SNVL - NVL for strings
- F_SNVL2 - variant of NVL for strings
- F_INVL - NVL for integer
- F_INVL2 - variant of NVL for integer
- F_DNVL - NVL for double
- F_DNVL2 - variant of NVL für double
New: spezial-version frr Eisfair1-server (and other systems with glibC < 2.3 ?)
The windows 32-bit-version is compiled with the openWatcon compiler from now on.
Clearance of source-code
update manual
update DECLARE-scripts

new and fixed versions tested with
- InterBase 7.5 SP1 with MandrivaLinux 2008.0
- InterBase 2009 with Windows XPSP2
- FireBird 1.5.5 with Windows2000 Advanced Server SP4
- FireBird 1.5.5 with MandrivaLinux 10.2 (LE 2005)
- FireBird 2.0.3 with Eisfair 1.5.4 Eiskernel 1.6.0
- FireBird 2.1.1 with openSuse 11.0
- FireBird 2.5.0alpha1 with Windows XPSP2
- FireBird 2.5.0alpha1 with ubuntu Desktop 8.04.1 LTS
- FireBird 2.5.0alpha1 amd64 with ubuntu Desktop 8.04.1 amd64 LTS
nach oben • go top •
Version "adhoc20080303" from 2008-03-03
some changed functions
fixes bug (maybe server-crash) in
- F_STRINGLISTITEM
- F_UUID1COMPRTIMESTAMP
- F_INCDATE
- F_INCDATETIME
- F_ADDWEEK
- F_ADDDAY
- F_ADDHOUR
- F_ADDMINUTE,
- F_ADDSECOND
- F_WEIBERFASSNACHT
- F_ROSENMONTAG
- F_KARNEVALSDIENSTAG
- F_ASCHERMITTWOCH
- F_PALMSONNTAG
- F_GRUENDONNERSTAG
- F_KARFREITAG
- F_OSTERSAMSTAG
I hope this theme with memory allocation/-free has passed now.
Fixes DECLARE-Scripts
From this version there is also a 32-bit-version compiled with the OpenWatcom compiler (for field-testing).
Because of this, the both functions F_UUID1TIMESTAMP and F_UUID1COMPRTIMESTAMP are now also thread-safe.
nach oben • go top •
Version "adhoc20080219" from 2008-02-19
2 changed functions
- F_FIXEDPOINTLANG - bug: if you choose no decimal place, the thousands separator had been set on wrong place.
- F_ADDYEAR - bug: input 29.2. in a output non-leapyear.
5 (+3) new date-functions
- F_COUNTWEEKDAYS
- F_DATETOSTRLANG (language version of F_DATETOSTR)
- F_ISOWOY (version of F_WOY with calculation week of year ISO)
- F_AGEINWEEKSISO (ISO-version of F_AGEINWEEKS with monday 1st day of week)
- F_AGEINWEEKSNULLISO (ISO-version of F_AGEINWEEKSNULL with monday 1st day of week)
- F_AGEINWEEKSTHRESHOLDISO (ISO-version of F_AGEINWEEKSTHRESHOLD with monday 1st day of week)
- F_AGEINWEEKSTHRESHOLDNULLISO (ISO-version of F_AGEINWEEKSTHRESHOLDNULL with monday 1st day of week)
- F_WEEKSBETWEENISO (ISO-version of F_WEEKSBETWEEN with monday 1st day of week)
2 new string-functions
- F_DOMAINFROMEMAIL (extrahiert die Domain aus einer eMail-Adresse)
- F_ROT13 (very simple encryption)
40 new conversion-functions
- F_C_FUR2M
- F_C_M2FUR
- F_C_CH2M
- F_C_M2CH
- F_C_RD2M
- F_C_M2RD
- F_C_LI2M
- F_C_M2LI
- F_C_LEA2KM
- F_C_KM2LEA
- F_C_SHOT2M
- F_C_M2SHOT
- F_C_CBL2M
- F_C_M2CBL
- F_C_NL2M
- F_C_M2NL
- F_C_NM2M
- F_C_M2NM
- F_C_CUIN2CUM
- F_C_CUM2CUIN
- F_C_CUFT2CUB
- F_C_CUB2CUFT
- F_C_CUYD2CUB
- F_C_CUM2CUYD
- F_C_CUP2ML
- F_C_ML2CUP
- F_C_ST2G
- F_C_G2ST
- F_C_CWT2G
- F_C_G2CWT
- F_C_LBFT2NM
- F_C_NM2LBFT
- F_C_MPUSGAL2L100KM
- F_C_L100KM2MPUSGAL
- F_C_MPGBGAL2L100KM
- F_C_L100KM2MPGBGAL
- F_C_MPH2KMPH
- F_C_KMPH2MPH
- F_C_FPS2MPS
- F_C_MPS2FPS
- F_C_SMPH2KMPH
- F_C_KMPH2SMPH
update manual
update DECLARE-scripts
fixed and new functions of this version are tested with
- InterBase 7.5 SP1 with MandrivaLinux 2008
- InterBase 2007 with Windows XPSP2
- FireBird 1.5.4 with Windows2000 Advanced Server SP4
- FireBird 1.5.3 with MandrivaLinux 10.2 (LE 2005)
- FireBird 2.0.3 with Windows XPSP2
- FireBird 2.0.3 with ubuntu server 6.06 LTS
- FireBird 2.0.1 amd64 with ubuntu server 6.06 amd64 LTS
nach oben • go top •
Version "adhoc20071203" from 2007-12-03
some changed functions
fixes memory leak of some BLOb- and string-functions
the ib_util_malloc function from the ib_util is used again. Therefore it is necessary again to link the ib_util.lib during compiling/linking.
nach oben • go top •
Version "adhoc20071128" from  2007-11-28
some changed functions
fixes bug in F_UPPER
fixes bug in F_LOWER
fixes bug in F_GSOUNDEX
fixes bug in F_REPLACESTRING
fixes bug in BLOb-functions
fixes bug in F_ADDSECOND, F_ADDMINUTE, F_ADDHOUR, F_ADDDAY, F_ADDWEEK with negative add
3 new functions
(only for Win 1251 charset)
- F_RUPPER
- F_RLOWER
- F_RLATIN
update manual
update DECLARE-scripts
fixed functions of this version are tested with
- InterBase 7.5 SP1 with MandrivaLinux 2008
- InterBase 2007 with Windows XPSP2
- FireBird 1.5.4 with Windows2000 Advanced Server SP4
- FireBird 1.5.3 with MandrivaLinux 10.2
- FireBird 2.0.3 with Windows XPSP2
- FireBird 2.0.3 with ubuntu server 6.06 LTS
- FireBird 2.0.1 amd64 with ubuntu server 6.06 amd64 LTS
nach oben • go top •
Version "adhoc20070824" from 2007-08-24
fixes bug in F_REPLACESTRING for FireBird 2.0 under Linux
nach oben • go top •
Version "adhoc20070823" from 2007-08-23
fixes bugs in some BLOb-functions under 64Bit Linux, nearly all BLOb-functions reengineered.
nach oben • go top •
Version "adhoc20070809" from 2007-08-09
2 changed functions
fixes bug (Server-Crash) in
- F_INCDATE
- F_INCDATETIME
5 extended functions
24 new languages in F_CMONTHLONGLANG (you can display with ISO 8859_1)
     pt = Portuguese,
     nl = Dutch
     no = Norwegian, Bokmål
     se = Swedish
     dk = Danish
     fi = Finnish
     hu = Hungarian
     ie = Irish(Gaelic)
     ee = Estonian
     is = Icelandic
     al = Albanian
     va = Classical Latin
     v1 = Ecclesiastical Latin
     c1 = Catalan
     s1 = Scots
     s2 = Scottish Gaelic
     w1 = Welsh
     b1 = Breton
     b2 = Basque
     n1 = Norwegian, Nynorsk
     za = Afrikaans
     fo = Faroese
     lu = Luxembourgish
     w2 = Wallon
24 new languages in F_CMONTHSHORTLANG look above
24 new languages in F_CDOWLONGLANG look above
24 new languages in F_CDOWSHORTLANG look above
24 new languages in F_NUMINWORDS look above
14 new functions
- F_KALENDERWOCHE
- F_WEIBERFASSNACHT
- F_ROSENMONTAG
- F_KARNEVALSDIENSTAG
- F_ASCHERMITTWOCH
- F_PALMSONNTAG
- F_GRUENDONNERSTAG
- F_KARFREITAG
- F_OSTERSAMSTAG
- F_OSTERMONTAG
- F_HIMMELFAHRT
- F_PFINGSTSONNTAG
- F_PFINGSTMONTAG
- F_FRONLEICHNAM
now input/output-compatible to the rest of rFunc string-functions
for this 5 new functions
- F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM)
- F_STRREPEAT (STRREPEAT, LONGSTRREPEAT)
- F_STRSTUFF (STRSTUFF, LONGSTRSTUFF)
- F_FLOATTOSTR (FLOATTOSTR)
- F_INTTOSTR (INTTOSTR)
now input/output-compatible to the rest of rFunc BLOb-functions
for this 3 new functions
- F_BLOBSTRPOS (B_STRPOS)
- F_BLOBCMP (B_STRCMP)
- F_BLOBTEXTPOS (B_TEXTPOS)
these rFunc-functions are not made until tody:
not yet input/output-compatible to rFunc spezial-functions
- EAN13CS
- CALCEXPR
- EXPRISVALID
not yet input/output-compatible to rFunc NVL-functions
- IIF
- DIF
- CIF
- LONGCIF
- DTIF
update manual
update DECLARE-scripts
now also a 64Bit-linux-version for AMD64 available
delete debug-code from the windwos-version, by this the dll is now much smaller
the ib_util_malloc function from the ib_util is not longer used. Therefore it is not longer necessary to link the ib_util.lib during compiling/linking.
Version tested on
- InterBase 7.1 with MandrivaLinux 2006
- InterBase 2007 with Windows XPSP2
- FireBird 1.5.4 with Windows2000 Advanced Server
- FireBird 1.5.3 with MandrivaLinux 10.2
- FireBird 2.0.1 with Windows XPSP2
- FireBird 2.0.1 with ubuntu server 6.06 LTS
- FireBird 2.0.1 amd64 with ubuntu server 6.06 amd64 LTS
- FireBird 2.1.beta1 with MandrivaLinux 2007
nach oben • go top •
Interim-version "adhoc 20070511beta" from 2007-05-11 - not published
nach oben • go top •
Version "adhoc20070209" from 2007-02-09
7 fixed, 39 new functions
now also compatibility for negativ parameters in FreeUDFLib etc. (empty string instead of complete string) for
- F_LEFT
- F_MID
- F_RIGHT
now compatibility for single-digit calender-weeks in FreeUDFLib etc. (leading 0) for
- F_WOY
fixes memory-leak with negative parameters in
- F_STROFCHAR
fixes bugs  in
- F_PROPERCASE (no transform of upper cases to lower cases)
- F_FIXEDPOINTLANG (wrong rounding and output at the end ':' instead of 0 if there is 9 at the end)
adds new (7 funktions):
string funnctions
- F_ KEYUP
numeric functions
- F_NUMINWORDS
- F_ROUNDTOEVEN
date/time functions
- ADDPERIOD
- SUBPERIOD
- PERIOD2SECONDS
- SECONDS2PERIOD
now input/output-compatible to nearly all rFunc string-functions
for this add
- F_RPADLEFT (PADLEFT, LONGPADLEFT)
- F_RPADRIGHT (PADRIGHT, LONGPADRIGHT)
- F_STRPOS (STRPOS)
- F_STRCMP (STRCMP)
- F_RSTRINGCOUNT (STRCOUNT)
- F_RWORDCOUNT (WORDCOUNT)
- F_WORDNUM (WORDNUM, LONGWORDNUM)
- F_RC (C, LONGC)
- F_CONVERTSYMBOLS (CONVERTSYMBOLS, LONGCONVERTSYMBOLS)
not yet made
- REPEATTRIM
- STRREPEAT
- STRSTUFF
- FLOATTOSTR
- INTTOSTR
now input/output-compatible to all rFunc Math-functions
for this add
- F_DIV (DIV)
- F_Z (Z)
- F_DZERO (DZERO)
- F_GETRANDOM (GETRANDOM)
- F_BIN_GET (GETBIT)
- F_BIN_SET (SETBIT)
now input/output-compatible to all rFunc date/time-functions
for this add
- F_EXTRACTYEARDAY (EXTRACTYEARDAY)
- F_EXTRACTWEEKDAY (EXTRACTWEEKDAY)
- F_RISLEAPYEAR (ISLEAPYEAR)
- F_MILLISECOND (EXTRACTMILLISECOND)
- F_DATETOSTR (DATETOSTR)
- F_RENCODEDATE (ENCODEDATE)
- F_RENCODEDATETIME (ENCODEDATETIME)
- F_DOW (DOW)
- F_FIRSTDAYMONTH (FIRSTDAYMONTH)
- F_LASTDAYMONTH (LASTDAYMONTH)
- F_INCDATE (INCDATE)
- F_INCDATETIME (INCDATETIME)
- F_TIMETODOUBLE (TIMETODOUBLE)
- F_DATETODOUBLE (DATETODOUBLE)
- F_DOUBLETODATE (DOUBLETODATE)
- F_DOUBLETOTIME (DOUBLETOTIME)
now input/output-compatible to nearly all rFunc BLOb-functions
- F_RBLOBMID (B_SUBSTR, B_LONGSUBSTR)
not yet made
- B_STRCMP
- B_TEXTPOS
now input/output-compatible to all rFunc UUID-functions
- for this no new functions necessary
now input/output-compatible to all rFunc constant-functions
- for this no new functions necessary
not yet input/output-compatible to rFunc spezial-functions
- EAN13CS
- CALCEXPR
- EXPRISVALID
not yet input/output-compatible to rFunc NVL-functions
- IIF
- DIF
- CIF
- LONGCIF
- DTIF
No compatibility will come to some rFunc-functions because
- they are only for Windows (and not or only with much work portable to Linux)
- only to use with kyrillic charset
- InterBase/FireBird system-function
- not (longer) necessary
These Windows-functions are
- FCREATE
- FOPEN
- FREAD
- LONGFREAD
- FWRITE
- FSEEK
- FCLOSE
- FREMOVE
- FSIZE
- FSEEK_CUR
- FSEEK_END
- FSEEK_SET
- FO_RDONLY
- FO_WRONLY
- FO_RDWR
- FO_CREAT
- FO_TRUNC
- FO_EXCL
- FO_APPEND
- FS_IREAD
- FS_IWRITE
- FS_IEXEC
- MSGBOX
only to use with kyrillic charset are
- NUMINWORDS
- RLATIN
- LONGRLATIN
- RTRANSLIT
- LONGRTRANSLIT
InterBase/FireBird system-functions are
- ADD_USER
- MODIFY_USER
- DELETE_USER
not (longer) necessary are
- INITRANDOM (because the random-functions initializes itsself)
- LIBVERSION
- LIBNAME
- MD5SUM
- MD5INIT
- MD5UPDATE
- MD5FINAL 
nach oben • go top •
Interim-version "adhoc20070130interim" from 2007-01-30 - not published
Interim-version "adhoc20070122interim" from 2007-01-22 - not published
Interim-version "adhoc20070118interim" from 2007-01-18 - not published
nach oben • go top •
Version “adhoc 20061221" from 2006-12-21
deletes (function without sence)
- F_UUIDCOMPARE
adds (131 functions):
String functions
- F_ORD
- F_PRED
- F_SUCC
- F_PADCENTER
- F_REVERSE
- F_WORDCOUNT
- F_STRINGCOUNT
Numeric functions
- F_EVEN
- F_RAND
- F_DOUBLERANDOM
- F_SIGN
- F_SQRT
- F_LN
- F_LOG
- F_LOG10
- F_FLOOR
- F_FRAC
- F_CEILING
- F_POWER
- F_SOFTROUND
Numeric functions: Trigonometry
- F_SIN
- F_COS
- F_TAN
- F_COT
- F_ASIN
- F_ACOS
- F_ATAN
- F_ATAN2
- F_ACOT
- F_SIND
- F_COSD
- F_TAND
- F_COTD
- F_ARCSIND
- F_ARCCOSD
- F_ARCTAND
- F_ARCCOTD
- F_SINH
- F_COSH
- F_TANH
- F_COTH
- F_ARSINH
- F_ARCOSH
- F_ARTANH
- F_ARCOTH
Numeric functions: Binär
- F_BIN_AND
- F_BIN_OR
- F_BIN_XOR
- F_BIN_NOT
- F_BIN_SHL
- F_BIN_SHR
BLOb functions
- F_BLOBWORDCOUNT
Convert functions
- F_C_IN2M
- F_C_FT2M
- F_C_YD2M
- F_C_MILE2KM
- F_C_SM2KM
- F_C_FM2M
- F_C_P2MM
- F_C_M2IN
- F_C_M2FT
- F_C_M2YD
- F_C_KM2MILE
- F_C_KM2SM
- F_C_M2FM
- F_C_MM2P
- F_C_AR2SQM
- F_C_HA2SQM
- F_C_MORGEN2SQM
- F_C_SQFT2SQM
- F_C_AC2SQM
- F_C_SQYD2SQM
- F_C_SQM2AR
- F_C_SQM2HA
- F_C_SQM2MORGEN
- F_C_SQM2SQFT
- F_C_SQM2AC
- F_C_SQM2SQYD
- F_C_BBL2L
- F_C_GBFLOZ2ML
- F_C_USFLOZ2ML
- F_C_GBPT2L
- F_C_USPT2L
- F_C_GBQT2L
- F_C_USQT2L
- F_C_GBGAL2L
- F_C_USGAL2L
- F_C_RT2CBM
- F_C_L2BBL
- F_C_ML2GBFLOZ
- F_C_ML2USFLOZ
- F_C_L2GBPT
- F_C_L2USPT
- F_C_L2GBQT
- F_C_L2USQT
- F_C_L2GBGAL
- F_C_L2USGAL
- F_C_CBM2RT
- F_C_CT2G
- F_C_OZ2G
- F_C_OZTR2G
- F_C_LB2KG
- F_C_G2CT
- F_C_G2OZ
- F_C_G2OZTR
- F_C_KG2LB
- F_C_G2T
- F_C_BAR2TORR
- F_C_BAR2PA
- F_C_PSI2PA
- F_C_TORR2PA
- F_C_CAL2J
- F_C_PS2KW
- F_C_BHP2KW
- F_C_T2G
- F_C_TORR2BAR
- F_C_PA2BAR
- F_C_PA2PSI
- F_C_PA2TORR
- F_C_J2CAL
- F_C_KW2PS
- F_C_KW2BHP
- F_C_C2F
- F_C_F2C
- F_ROMAN2ARABIC
- F_ARABIC2ROMAN
Functions for constants
- F_PI
- F_E
- F_C
- F_G
- F_K
corrects bugs
- in F_PROZENTE
- with negative numbers in F_ZAHLRUNDEN
- to round under Linux in F_ZAHLRUNDEN
Changing from enteypoints:
- F_TRUNCATE now f_truncate insteed of truncate
- F_ROUND now f_round insteed of round
Compatible to FB 2.0 - UDFs now could return <null>
Update manual
Functions tested
- InterBase 7.1 with MandrivaLinux 2006
- InterBase 2007 with Windows XPSP2
- InterBase 2007 with MandrivaLinux 2006
- FireBird 2.0 with Windows XPSP2 without <null> Declairs
- FireBird 2.0 with Windows XPSP2 with <null> Declairs
- FireBird 2.0 with MandrivaLinux 2006
nach oben • go top •
Version “adhoc 20061031" from 2006-10-31
adds:
- F_NBSP
- F_DQM
- F_SQM
- F_TAB
- F_INTRANDOM
- F_UUID1MAC
- F_UUID1RAND
- F_UUID1MACCOMPR
- F_UUID1RANDCOMPR
- F_UUID4
- F_UUID4COMPR
- F_UUID2UUIDCOMPR
- F_UUIDCOMPR2UUID
- F_UUIDCOMPARE
- F_UUID1TIMESTAMP
- F_UUID1COMPRTIMESTAMP
- F_UUID1MACMAC
- F_UUID1COMPRMAC
- F_UUIDVERSION
update manual
(new functions) tested with
- InterBase 7.1 SP2 with Windows 2000 Advanced Server
- InterBase 7.1 SP2 with Mandriva Linux 2006
- InterBase 7.5 SP1 with Windows XP Professional
- InterBase 7.5 SP1 with Mandriva Linux 2006
- InterBase 2007 with Windows XP Professional
- FireBird 1.5.2 with Windows 2000 Advanced Server
- FireBird 1.5.2 with SuSe 10.0
- FireBird 1.5.2 with Mandriva Linux 2006
- FireBird 2.0 RC5 with Windows XP Professional
- FireBird 2.0 RC5 with Mandriva Linux 2006
nach oben • go top •
Version “adhoc 20060925" from 2006-09-25
Bugfix (with server-crash) for InterBase and FireBird in:
- F_BLOBASPCHAR
- F_BLOBCAT
- F_BLOBCATSTR
- F_BLOBREPLACESTRING
Bugfix for Linux:
- F_DAYSOFMONTHS
adds:
- F_BLOBMAXSEGMENTLENGTH
- F_BLOBSEGMENTCOUNT
- F_BLOBLINE
- F_BLOBLINE_COUNT
- F_BLOBCOMPARE
- F_BLOBSUBSTR
update manual
(new functions) tested with
- InterBase 7.1 SP2 with Windows 2000 Advanced Server
- InterBase 7.1 SP2 with Mandriva Linux 2006
- InterBase 7.5 SP1 with Windows XP Professional
- InterBase 7.5 SP1 with Mandriva Linux 2006
- FireBird 1.5.2 with SuSe Linux 8.1
- FireBird 1.5.2 with SuSe Linux 10.0
- FireBird 1.5.2 with Mandriva Linux 2006
- FireBird 2.0 RC4 with Windows XP Professional
- FireBird 2.0 RC4 with Mandriva Linux 2006
nach oben • go top •
Interim-version “adhoc 20060919 from 2006-09-19 - not published
nach oben • go top •
Version “adhoc 20060516" from  2006-05-16
- adapted to InterBase 7.5
- works on from FireBird 2.0 RC1 (compiled with RC2)
- with Windows from FireBird 1.5 on only one FreeAdhocUDF-FireBird version is necessary
- with Windows from InterBase 6 on only one FreeAdhocUDF-InterBase version is necessary
- only for Linux and FireBird 1.5 a version a special version is necessary 
- for Linux and InterBase just one version of FreeAdhocUDF is necessary 
- no more support for Interbase 6 and SuSe 8.1
- corrects a bug in F_AGEINYEARSTHRESHOLD (Parameters changed)
- corrects a bug in F_ADDMONT       
- error correction and update of the manual
This version was testet on:
- InterBaseSS 6.02 with Windows XP Professional and Windows 2000 Advanced Server
- InterBase 7.1 with Windows XP Professional and Windows 2000 Advanced Server
- InterBase 7.1 with Mandrake Linux 10.0 / Mandriva Linux 10.1
- InterBase 7.5 with Windows2000 Advanced Server
- InterBase 7.5 with Mandriva Linux 10.2
- FireBirdSS 1.5.2 with Windows XP Professional and Windows 2000 Advanced Server
- FireBirdSS 1.5.2 with Mandrake Linux 10.0 / Mandriva Linux 10.1
- FireBirdSS 1.5.2 with SuSe Linux 8.1 (use FreeAdhocUDF.so SuSe81FB15 !)
- FireBirdSS 1.5.2 with SuSe EnterpriseServer 8 (use FreeAdhocUDF.so SuSe81FB15 !)
- FireBirdSS 1.5.2 with SuSe Linux 10.0
- FireBirdSS 1.5.2 with Ubuntu Server 5.10
- FireBirdSS 1.5.2 with Kubuntu 5.10
- FireBirdSS 2.0.0 RC2 with Windows 2000 Advanced Server 
- FireBirdSS 2.0.0 RC2 with Mandriva Linux
nach oben • go top •
Version "adhoc 20060509" from 2006-05-09

nach oben • go top •
Version “adhoc 20060306" from 2006-03-06
adds:
- a variant to F_SUBSTR because of compatibility to (Delphi-)FreeUDFLib
nach oben • go top •
Version “adhoc 20060302" from 2006-03-02
adds:
- F_STRINGLISTITEM
- F_LF
- F_STR2EXCEL
- F_BLOB2EXCEL
- F_BLOBCAT
- F_BLOBCATSTR
- F_BLOBREPLACESTRING
corrects (the same) bug in
- F_ADDYEAR
- F_ADDMONTH
- F_ADDWEEK
- F_ADDDAY
- F_ADDHOUR
- F_ADDMINUTE,
- F_ADDSECOND
extended version of
- F_FINDWORD and F_FINDNTHWORD additional character (äöü...)
update manual
nach oben • go top •
Version "adhoc 20051231" from 2005-12-31
bugfixed on following bugs:
- F_OSTERDATUM (calulates Thuesday after Easter insted of Easter-Sunday)
- UDF-definitionscript (wrong Entrypoint of F_MAX and F_MIN)
update manual
nach oben • go top •
Version "adhoc 20051016" from 2005-10-16
produced compatibility between Windows and Linux for InterBase and FireBird and is compatible to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP and GrUDF.  It contains new Functions, which did not give it so far in one of the four UDFs, which are however useful.
- F_VERSION
- F_EUROVAL
- F_ROUND
- F_DIGITS
- F_STRIPSTRINGHOLD
- F_FACT
- F_FIXEDPOINTLANG
- F_AGEINYEARS
- F_AGEINYEARSTHRESHOLD
- F_AGEINHOURS
- F_AGEINHOURSTHRESHOLD
- F_AGEINMINUTES
- F_AGEINMINUTESTHRESHOLD
- F_AGEINSECONDS
- F_AGEINSECONDSTHRESHOLD
- F_YEARSBETWEEN
- F_MONTHSBETWEEN
- F_WEEKSBETWEEN
- F_DAYSBETWEEN
- F_HOURSBETWEEN
- F_MINUTESBETWEEN
- F_SECONDSBETWEEN
- F_ADDWEEK
- F_ADDDAY
- F_ADDHOUR
- F_ADDMINUTE
- F_ADDSECOND
- F_ENCODEDATE
- F_ENCODETIME
- F_ENCODETIMESTAMP
- F_LASTDAY
- F_STRRM
- F_STRCOPY
nach oben • go top •
1st Version (without VersionsNo.) from 2004-08-23
produced compatibility between Windows and Linux for InterBase and was Compatible with the FreeUDFLib and the FreeUDFLibC.  It contained moreover some new Functions.    
- F_LOWER
- F_UPPER
- F_MAXNUM
- F_MINNUM
- F_CMONTHLONGLANG
- F_CMONTHSHORTLANG
- F_CDOWLONGLANG
- F_CDOWSHORTLANG
- F_DAYSOFMONTH
- F_DTIME
- F_GFORMATD
- F_TELEFONNR
- F_IF
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site