Wise Owl Answers - How do I count the rows in an ADODB recordset?

Описание: Check out our other answers here    • Wise Owl Answers  

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Get files here https://www.wiseowl.co.uk/vba-macros/...

This video explains how to use the RecordCount property of an ADODB recordset to find out how many rows your query has returned. You'll learn how to set the cursor type and the basic differences between ForwardOnly, Static, Keyset and Dynamic cursors.

Chapters
00:00 The Question
01:54 The RecordCount Property
02:59 Changing the Recordset Cursor Type
04:29 Checking for No Records Returned

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more