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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!