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
 

Reply via email to