Command String

[lothos12345]

I have a Visual Basic.Net application and for the data interface I am using Access I am feeding it a command string as follows:

VarTemp = "SELECT IFIELD1, IFIELD2, IFIELD3, IFIELD4, IMAGELIST, IDNUM FROM INDEXDB1 WHERE (IFIELD1 LIKE BN*) OR (IFIELD1 LIKE BR*) OR (IFIELD1 LIKE ES*) OR (IFIELD1 LIKE IG*) OR (IFIELD1 LIKE WZ*)"


This always returns nothing however when I put this same string in an Access query it returns what I expect it to return.

Also from the application when I feed it the sql command:

VarTemp = "SELECT IFIELD1, IFIELD2, IFIELD3, IFIELD4, IMAGELIST, IDNUM FROM INDEXDB1"

It works as expected too. The issue I have is when I use the where clause and only when I use it from the program. There is something wrong with how I am feeding the where clause from the program though I am not sure what. Any help offered is greatly appreciated.

 

[kejpa]

Hi,
have you tried to change the * to a %
In my experience it has made a difference in some cases.
% is the standardSQL wildcard token, M$ took what you use in DOS and used it within Access to "help" people.
* is standardSQL token for "all fields" as in select * from Names

HTH
/Kejpa