what command do I use to search a adoco database?

I am using the ODBC interface and the adoco1 unit has interfaced correctly

but evrytime I try to search using the select from and where commands it just does not find anything

Can some please help

Is the searching a adoco different then a ado data control?