This is my UDF source 

library pudf; 
  {$mode objfpc}{$H+} 
uses 
  Classes; 

function pround(var valore: real; ndec: integer):real;export; 
var 
  i: integer; 
  risultato: real; 
  ndivisore: integer; 
begin 
  risultato:= valore; 
  ndivisore:= 1; 
  for i:= 1 to ndec do 
  begin 
    risultato:= risultato*10; 
    ndivisore:= ndivisore*10; 
  end; 
  result:= round(risultato)/ndivisore; 
end; 

exports 
  pround name 'pround'; 

begin 
end. 

but after insert into my fdb with instruction 

DECLARE EXTERNAL FUNCTION pround 
DOUBLE PRECISION, INTEGER 
RETURNS DOUBLE PRECISION BY VALUE 
ENTRY_POINT 'pround' MODULE_NAME 'pudf'; 

if I use it with an instruction like this 

select round(123.1233, 2) as nrounded from rdb$database 

I have back this error 

Invalid token. 
invalid request BLR at offset 59. 
function PROUND is not defined. 
module name or entrypoint could not be found. 

do you have some idea regarding this error?

Codebue Fabio
.-----------------------------.
  _ \       __|       _||
  __/____|\__ \  _ \  _| _|
 _|       ____/\___/_| \__|

P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 - Chiuduno - BG
Italy
Phone: +39.030.839435
Fax: +39.030.5100306
Mobile: +39.348.3515786
.-----------------------------.
Web  : www.p-soft.biz
EMail: [EMAIL PROTECTED]  


_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Reply via email to