installed enterprise professional services 7

installed qodbc

ran the vb6 demo

select * from customers returns all rows //no problem

I tried

select * from customer where name = 'Bayshore'   //first item in customer table

no results

strange.  Am I missing something?

Sorry, I hate to say it, but I don't think you actually have a customer just named 'Bayshore' . Check that you have the whole name. Here I do the same thing:-

SELECT * FROM Customer

and run a query for the first name

SELECT * FROM CUSTOMER where Name='Family Room'

However, this isn't uique and isn't indexed with a jump-in.

So, for the best results, always use FullName:

SELECT * FROM Customer where FullName='Abercrombie, Kristy:Family Room'

Hey Tom

You're correct

The name was Bayshore Chamber of Commerce

the column spacing made it look like one word but there were in fact several.