I am trying to populate a recordset in visual basic 6.0 .
The query i am trying to execute is :
select instrrev(linkfile,'') from importcode
here importode is a table and linkfile is a field in it in Ms-Access. but when i execute the recordsetobject.open statement with this query it gives the following error.
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'instrrev' in expression.