SQL with VB6!

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? :)

Recommend spending several minutes reviewing the Database FAQ.

Once you have a connection object opened to your database, the query will be used in the .Execute method of the connection object to return a recordset or used in the .Open method of a recordset object.

Either way, the count can be determined by the .RecordCount of the recordset object.

The FAQ page has examples also.

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)