Subject | Re: [firebird-support] Problem Using MOD |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-07-19T06:13:22Z |
Hi Nairo,
I tried to use this MOD function with the definition u have given
DECLARE EXTERNAL FUNCTION MOD
INTEGER,
INTEGER
RETURNS INTEGER
ENTRY_POINT 'IB_UDF_mod' MODULE_NAME 'ib_udf';
But when I try to execute the query
'select Mod(2000,19) from RDB$database;' ,
my server (service) stops after giving me some me some vague numbers as output of this query.
I don't know what all is goin' around.
Can anyone look into it?
Thanx.
Mahesh.
Nairo Granados <nairox@...> wrote:
Hi All,
I'm using the function MOD in a stored procedure in Firebird 1.5 to
get the remainder of a division but the operation get the wrong
result.
For Example
A = MOD(2000, 19);
The result is 105 instead of 5.
I don't know why is this happen. Somebody could help me???
This is the UDF function
DECLARE EXTERNAL FUNCTION MOD
INTEGER,
INTEGER
RETURNS INTEGER
ENTRY_POINT 'IB_UDF_mod' MODULE_NAME 'ib_udf';
Thanks a lot,
Nairo Granados
Yahoo! Groups SponsorADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]
I tried to use this MOD function with the definition u have given
DECLARE EXTERNAL FUNCTION MOD
INTEGER,
INTEGER
RETURNS INTEGER
ENTRY_POINT 'IB_UDF_mod' MODULE_NAME 'ib_udf';
But when I try to execute the query
'select Mod(2000,19) from RDB$database;' ,
my server (service) stops after giving me some me some vague numbers as output of this query.
I don't know what all is goin' around.
Can anyone look into it?
Thanx.
Mahesh.
Nairo Granados <nairox@...> wrote:
Hi All,
I'm using the function MOD in a stored procedure in Firebird 1.5 to
get the remainder of a division but the operation get the wrong
result.
For Example
A = MOD(2000, 19);
The result is 105 instead of 5.
I don't know why is this happen. Somebody could help me???
This is the UDF function
DECLARE EXTERNAL FUNCTION MOD
INTEGER,
INTEGER
RETURNS INTEGER
ENTRY_POINT 'IB_UDF_mod' MODULE_NAME 'ib_udf';
Thanks a lot,
Nairo Granados
Yahoo! Groups SponsorADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]