Information on how to use the dow() UDF

By: Borland Staff

Abstract: Getting the error .."error 171: function dow() could not be matched..

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                                

Server Response from: ETNASC03