nfuids
asked on
VB & LIKE clause!
Hello!
I developped a VB program that use Access as its DB backend. All my query are successful but one which is:
SELECT * FROM tblClients WHERE (tblClients.Nom) Like 'camio*' ORDER BY Nom
the above is generated from my VB program (I pasted it from the VB Espions. It returns 0 rows but when I paste this query directly into Access, it returns 50 rows which are what I would like to happen in my VB program :)
If anyone has a tips or a pointer to the right direction to use.. I'd appreciate it.
Mart
I developped a VB program that use Access as its DB backend. All my query are successful but one which is:
SELECT * FROM tblClients WHERE (tblClients.Nom) Like 'camio*' ORDER BY Nom
the above is generated from my VB program (I pasted it from the VB Espions. It returns 0 rows but when I paste this query directly into Access, it returns 50 rows which are what I would like to happen in my VB program :)
If anyone has a tips or a pointer to the right direction to use.. I'd appreciate it.
Mart
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I thought I had tried it.. but I guess not :P