ADO Primer Examples

---

Database 101 Series © 2000 Rey Nuñez
(provided to you by courtesy of Neva Tavoada)

Primer Connection Method Part II: Displaying Viewing Records Viewing Records II List Records Selecting Records Filtering Records OpenSchema Method Fields Collection

Part III: Searching Login SQL Search SQL Search Filter Find (Order By) method Find (Sort) method Part IV: Updating ADO AddNew method SQL Insert ADO Update method SQL Update ADO Delete method SQL Delete

Part V: Navigating Move method Recordset Paging Part VI: SQL Basics SQL Calculated Fields SQL Where Clause SQL Where ... In Clause SQL Inner Join SQL Left Join SQL Right Join SQL Aggregate Functions SQL Sum, Group By and Order By SQL Order By ADO Prepared Property