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.
March 21, 2006 11:13 PM
March 29, 2006 7:59 AM