TOP をテンプレートにして作成
ホーム
バックアップ
一覧
検索
最終更新
ヘルプ
ログイン
開始行
External Functions (UDFs)
Table of Contents
Ability to Signal SQL NULL via a Null Pointer
UDF library diagnostic messages improved
UDFs Added and Changed
General UDF Changes
Ability to Signal SQL NULL via a Null Pointer
C. Valderrama
Previous to Firebird 2, UDF authors only could guess that...
For a numeric value, the author could not always assume n...
Several UDFs, including the ib_udf library distributed wi...
However, but it is not applicable to VARCHAR or CSTRING, ...
The other solution was to rely on raw descriptors, but th...
Since UDFs have no formal mechanism to signal errors, the...
The basic problem was to keep the simplicity of the typic...
The engine normally passed UDF parameters by reference. I...
The solution, therefore, is to restrict a request for SQL...
Example
declare external function sample
int null
returns int by value...;
If you are already using functions from ib_udf and want t...
Caution
It is recommended to do this when no other users are conn...
The code in the listed functions in that script has been ...
The functions won't crash if you don't upgrade: they will...
If you have never used ib_udf in your database and want t...
Note
Note the "2" at the end of the name.
The original script for FB v1.5 is still available in the...
UDF library diagnostic messages improved
A. Peshkov
Diagnostics regarding a missing/unusable UDF module have ...
UDFs Added and Changed
IB_UDF_rand() vs IB_UDF_srand()
IB_UDF_lower
UDFs added or enhanced in Firebird 2.0's supplied librari...
IB_UDF_rand() vs IB_UDF_srand()
F. Schlottmann-Goedde
In previous versions, the external function rand() sets t...
srand((unsigned) time(NULL));
return ((float) rand() / (float) RAND_MAX);
The problem with this algorithm is that it will return th...
To work around this issue, rand() was changed in Firebird...
In order to keep the legacy behaviour available in case s...
IB_UDF_lower
The function IB_UDF_lower() in the IB_UDF library might c...
/* ib_udf.sql declaration that now causes conflict */
DECLARE EXTERNAL FUNCTION lower
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
The problem will be resolved in the latest version of the...
/* New declaration in ib_udf2.sql */
DECLARE EXTERNAL FUNCTION "LOWER"
CSTRING(255) NULL
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
Tip
It is preferable to use the internal function LOWER() tha...
General UDF Changes
Build Changes
Build Changes
C. Valderrama Contributors
The FBUDF library no longer depends on [lib]fbclient to b...
最終行:
External Functions (UDFs)
Table of Contents
Ability to Signal SQL NULL via a Null Pointer
UDF library diagnostic messages improved
UDFs Added and Changed
General UDF Changes
Ability to Signal SQL NULL via a Null Pointer
C. Valderrama
Previous to Firebird 2, UDF authors only could guess that...
For a numeric value, the author could not always assume n...
Several UDFs, including the ib_udf library distributed wi...
However, but it is not applicable to VARCHAR or CSTRING, ...
The other solution was to rely on raw descriptors, but th...
Since UDFs have no formal mechanism to signal errors, the...
The basic problem was to keep the simplicity of the typic...
The engine normally passed UDF parameters by reference. I...
The solution, therefore, is to restrict a request for SQL...
Example
declare external function sample
int null
returns int by value...;
If you are already using functions from ib_udf and want t...
Caution
It is recommended to do this when no other users are conn...
The code in the listed functions in that script has been ...
The functions won't crash if you don't upgrade: they will...
If you have never used ib_udf in your database and want t...
Note
Note the "2" at the end of the name.
The original script for FB v1.5 is still available in the...
UDF library diagnostic messages improved
A. Peshkov
Diagnostics regarding a missing/unusable UDF module have ...
UDFs Added and Changed
IB_UDF_rand() vs IB_UDF_srand()
IB_UDF_lower
UDFs added or enhanced in Firebird 2.0's supplied librari...
IB_UDF_rand() vs IB_UDF_srand()
F. Schlottmann-Goedde
In previous versions, the external function rand() sets t...
srand((unsigned) time(NULL));
return ((float) rand() / (float) RAND_MAX);
The problem with this algorithm is that it will return th...
To work around this issue, rand() was changed in Firebird...
In order to keep the legacy behaviour available in case s...
IB_UDF_lower
The function IB_UDF_lower() in the IB_UDF library might c...
/* ib_udf.sql declaration that now causes conflict */
DECLARE EXTERNAL FUNCTION lower
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
The problem will be resolved in the latest version of the...
/* New declaration in ib_udf2.sql */
DECLARE EXTERNAL FUNCTION "LOWER"
CSTRING(255) NULL
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
Tip
It is preferable to use the internal function LOWER() tha...
General UDF Changes
Build Changes
Build Changes
C. Valderrama Contributors
The FBUDF library no longer depends on [lib]fbclient to b...
ページ名:
新規
名前変更
ホーム
一覧
検索
最終更新
バックアップ
ヘルプ
最終更新のRSS