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