Working with Database Records

Top  Previous  Next

 

Once you have connected to a database, you then have access to all the tables of records in that database.

 

Each page group in dbQwikSite uses a "Dataset", while very often a dataset is a database table, it does not have to be a single table.  It can be a query of several tables which contains subsets of fields available from those tables. This section covers topics that will help you create "Queries" which enable you to retrieve the data you need for your datasets from that available tables and fields in your database.

 

The Visual Query Builder

How to Build a Query

Adding Tables to Query

Selecting Fields for your Query

Joining Tables

Filtering Records

Sorting Data

Eliminating Duplicate Records

View SQL

Viewing Selected Data

Customizing the Query