You have not run the SQL script which defines/declares the function as a UDF.
Sean From: [email protected] [mailto:[email protected]] Sent: Monday, July 21, 2014 1:59 PM To: [email protected] Subject: [firebird-support] Unable to get F_AGEINDAYS function to work 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
