Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sql query in VB6 to access database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-05 : 08:33:46
martin writes "I am a bit of a newby when it comes to databases. I have written a vb6 database query editor which works fine. I am now trying to add a counter to give a count on the number of records returned in my query, and then put this information into a vb6 text box on a form. The way I currently show the returned information from my query is in an msflexigrid.

Regards,"

Kanati
Starting Member

36 Posts

Posted - 2002-09-05 : 11:49:38
not exactly sure what you are looking for here, but

rs.recordcount returns the number of records (assuming rs is an ado recordset). The just set textbox1.text = str(rs.recordcount)

don't think you need a "counter" per-se.

Kanati

Go to Top of Page
   

- Advertisement -