I'm trying to connect to a dbase table via MS Excel VBA using ADO and select some records, no problems so far. Where I hit a snag is when I incorporate a function into my SQL query. The function is defined as public and is in the same module as the rest of the code and is pretty simple, accepts a string as argument and returns a string, receiving null values is accounted for.
I get the following error msg:
-2147217900 microsoft odbc dbase driver undefined function 'Categorize' in expression
FROM sometable ......
Again, running the same query without the function works fine.
I could run the function on the recordset afterwards, but would like to do it all in the query itself....