I'm using either Remote Data Object or Remote Data Control and I still have problems with this.
This SQL statement doesn't return me any results, or errors:
SELECT fname FROM AUTHOR WHERE fname LIKE 'bl*';
fname is in access 97 db, set to text, required no, lenght 25
If I use this SQL in Access, it will return me 2 results, what is perfect.
Does anybody have any ideas, why VB would return me 0 results ?
I tried using Remote Data Control or creating a RDOEnvironment & in it, connection, query & resultset, but still it's like banging it in the wall.
All help or suggestions are highly appriciated.
Thank you in advance.
Alesh