Problem: Getting the error .."error 171: function dow() could not be matched.. Information on how to use the dow() UDF and details on locations for the funclib.dll While using the function dow() in the following query "select dow(post), count(*) from", user gets the following error message... "error 171: function dow could not be matched.." Solution: The information in this article applies to: * InterBase v4.x There are two specific issues in this problem.. Firstly dow() does not accept any arguments. It just converts the system time structure and returns the name of the current day of the week. select dow(), count(*) from job group by job_code; DOW COUNT ================== ================= Monday 1 Monday 3 Monday 1 ..... Secondly, you need to make sure that the funclib.dll is in the 'PATH' OR in the windows system directory. The second option is to have all your user defined function modules created in a separate directory and then have this directory included in your 'PATH'. On NT 3.51 running InterBase 4.0, you need to the following.... implib mygds32.lib ibserverbingds32.dll bcc32 -v -a4 -DWIN32 -tWM -tWCD -efunclib.dll myudflib.c mygds3 2.lib
Last Modified: 26-OCT-00