You have not run the SQL script which defines/declares the function as a UDF.

 

Sean

 

 

Good afternoon.

 

I  am trying to get the F_AGEINDAYS function to work without any success.

 

Here is my code:

select TOTSOLD_PRODUCT, TOTSOLD_QTYSOLD, F_AGEINDAYS(TOTSOLD_SOLDDATE, TOTSOLD_LISTDATE) as roi_days from TOTAL_SALES;

 

Here is the result:

 13:52:43  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 335544569, SQL State: HY000]  GDS Exception. 335544569. Dynamic SQL Error

SQL error code = -804

Function unknown

F_AGEINDAYS

 

We use Fishbowl inventory with Firebird as the database.

I have the FREEUDFLIB in   Program files (x86)/Fishbowl/Database/Bin/FREEUDFLIB

 

I use DBVisualizer as the database tool.

 

Is there something else I need to do?

 

Thank you very much for any help.

 

Jim