Well, i'm startiing with sql in vb6 and i have a few questions.

First:


I have to make this query:

SELECT [chname] FROM [database].[dbo].[table]

and it must return all the chnames of the table.

Second: i want to count the lines of the same query.

Anyone can help?