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
Necessary UPDATE for existing databases

Because it's possible in FireBird 2.0 that UDF return <null> instead of 0 or "empty string", the code of most functions must be changed basically to use this mechanism. So a "RETURN INTEGER BY VALUE" becomes a "RETURN INTEGER FREE_IT".
To use the functions of the new version with an old declaration, which includes a "BY VALUE", returned for example in SELECT F_HOUR('30.11.2006 15:00:00') FROM RDB$DATABASE something bullshit - a number with 8 places - but not 15.

Therefore it is in all cases necessary to change the old declarations with the new once - even you didn't want to use FireBird 2.0 or didn't want to use the <null> possibility.

If you have declared your FreeAdhocUDF with a version prior to version adhoc200612xx you have to delete the UDFs and to declare them new or - because you can't delete them insteed of dependendies - you have to use the UPDATE-scripts adhoc200612update_xxx.sql! You'll find them here in the Download area.

For UUID-functions there is no UPDATE-Script, you had to delete the declarations in the database and then rebuild them new with the new  DECLAIR-Script.

For function F_TRUNCATE we had so change the entrypoint from truncate to f_truncate to avoid conflicts with a  standard-function in C. This is also part of the UPDATE-Script.

The aktual DECLAIR-scripts are up to date.
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site