Count the no of records and no of columns in a table

by sumeet haldankar (5 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Mon 29^th July 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate Count the no of records and no of columns in a table




rs.open "select * from .........",conObject,adopendynamic,adlockoptimistic
rs.movelast
msgbox rs.recordcount ' returns no of records
msgbox rs.fields.count ' returns no of columns

Download this snippet Add to My Saved Code

Count the no of records and no of columns in a table Comments

No comments have been posted about Count the no of records and no of columns in a table. Why not be the first to post a comment about Count the no of records and no of columns in a table.

Count the no of records and no of columns in a table

Count the no of records and no of columns in a table Comments

Post your comment

Difficulty