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

sumeet haldankar (5 Submissions) Miscellaneous VB 6.0 Unknown Difficulty Mon 29^th July 2002 Mon 8^th February 2021

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

(1(1 Vote))



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 snippet Save to my list

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

No comments yet — be the first to post one!

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 a Comment