R
radloffe
Guest
I have an NEC MobilePro 790 running Windows HandHeld PC 2000 
. It has Pocket Access included in it's ROM. I have a knowledge base on my desktop PC in MS Access. If I query the Access database with the following SQL statement (the name of the table is "searchkb") :
Select * FROM "searchkb" WHERE searchkb.Keywords Like "*Lotus Notes*"
...the database then returns several rows of results from the knowledge base
.
I have exported/imported the access database into a .cdb file for pocket access. I've loaded it onto a Compact Flash MicroDrive in the MobilePro and all of the data is visible in the table view of pocket access
. All of the datatypes are the same (text), and the Keywords field is indexed.
However, when I perform the exact same SQL query as the statement I listed above, no results are returned
. It just returns a single blank row, and no errors are displayed. I tried many variations of SQL statements, and it appears the "Like" command keyword is not supported 
in pocket access, even though no errors are returned . If I write SQL statements with "is" instead of "like" they return results, but "is" statements only work for exact match criteria. The whole point of the knowledgebase is to be able to perform wildcard searches when you're not sure what you're looking for, so "is" statements are of no use.
I also tried moving the database into main memory and verified the data I'm searching for does actually exist in the pocket access version of the database
.
Is it true that "like" and wildcard searches are not supported by Pocket Access? Any ideas, either way? I'm looking for a "free"
wildcard search solution for data that is locally stored on the device. Any help would be appreciated.
. It has Pocket Access included in it's ROM. I have a knowledge base on my desktop PC in MS Access. If I query the Access database with the following SQL statement (the name of the table is "searchkb") :Select * FROM "searchkb" WHERE searchkb.Keywords Like "*Lotus Notes*"
...the database then returns several rows of results from the knowledge base
.I have exported/imported the access database into a .cdb file for pocket access. I've loaded it onto a Compact Flash MicroDrive in the MobilePro and all of the data is visible in the table view of pocket access
. All of the datatypes are the same (text), and the Keywords field is indexed.However, when I perform the exact same SQL query as the statement I listed above, no results are returned
. It just returns a single blank row, and no errors are displayed. I tried many variations of SQL statements, and it appears the "Like" command keyword is not supported in pocket access, even though no errors are returned . If I write SQL statements with "is" instead of "like" they return results, but "is" statements only work for exact match criteria. The whole point of the knowledgebase is to be able to perform wildcard searches when you're not sure what you're looking for, so "is" statements are of no use. I also tried moving the database into main memory and verified the data I'm searching for does actually exist in the pocket access version of the database
.Is it true that "like" and wildcard searches are not supported by Pocket Access? Any ideas, either way? I'm looking for a "free"
wildcard search solution for data that is locally stored on the device. Any help would be appreciated. 
