Thanks a lot , it works fine.<br>But can you tell me why is there so much change in SQL syntax with ADO and DAO<br>Eg. "like" changes to "alike" <br>And i had a problem earlier for the sql below <br>select * from user where password="hakim";<br>it would give error...
Dear friends,<br>my sql is as follows:<br><br>SELECT salesman_name, salesman_cd<br>FROM salesman<br>WHERE salesman_name like "*a*";<br><br>when i assign this query to ADO control it does not retrieve any records but the same query runs fine in access and displays 3 records.<br>Why does...
i used to have pretty much the same problem. it usually appeared after i forgot to change the tapes. to resolve it i had to restart the arcserve dbase engine, tape engine or restart the server. <br><br>regards, <br><br>Hakim
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.