Easy Tutorial
Ado Ref Error Ado Sort Ado Ref Record Ado Display Ado Command Index Ado Ref Stream Ado Tutorial Ado Connect Ado Intro Ado Query Ado Examples Ado Summary Ado Datatypes Ado Ref Recordset Ado Ref Field Ado Getstring Ado Add Ado Recordset Ado Ref Connection Ado Ref Parameter Ado Ref Property Ado Delete Ado Update
❮ Ado Intro Ado Examples ❯

ADO Query

We can use SQL to create queries, allowing us to specify viewing only selected records and fields.

Display Selected Data

We want to display only the records from the "Customers" table where the "Companyname" field starts with the letter A:

Example

More Examples

Display records where "Companyname" is greater than E

Display only customers from Spain

Let the user choose the filtering criteria

❮ Ado Intro Ado Examples ❯