Database Tour Documentation Contents Index

Typical Tasks Solutions



Here are described only a few examples of how Database Tour can be used.

Some examples are intended mainly for newbies.

In the examples, table and field names are hypothetical; use the names from your own database instead.

In the bigger part of the examples it is assumed that you have already connected the corresponding database.

Batch Change Field Contents

    Assign the same value 'Ronald' to all records in the field 'Name' of the table 'Clients'
    The same as the previous, but change only records where value in field 'Debt' is greater than 20
    Change all first symbols in all text fields of Animals table to upper case

Export Data

    Export data from a dBase (DBF) table to a new Paradox (DB) table
    Export data from a table to JSON
    Create a new table, which must consist of fields 'Name' and 'Street' from table 'Friends'
    Copy selected tables to another database

Import Data

    Add first two records in fields 'Capital' and 'Area' from 'Country' table into the fields 'Name' and 'Area' accordingly from 'City' table (from the same database)

Delete Records

    Delete records, where value of field 'Debt' is less than 10

Print Table Data

    Print a table or query
    Print the first and the third column from a table
    Print a table with totals for all numeric fields (Database Tour Pro only)
    Create a report with grouping records (Database Tour Pro only)
    Automate the following actions: Open 'WorkData' ODBC data source, 'City' table from this database, load report template from file C:\My templates\city.dtt and show the report preview (Database Tour Pro only)

Find and Replace Table Data

    Find the 'Bill' word in field 'Name'
    Replace all the 'Cat' words in the fields Animal and Description with the 'Mouse' word

Arithmetic Operations

    Get sum of numeric field 'Price' from 'Goods' table

Customize Table Data View

    Specify custom titles for data grid columns
    Specify the column pick list, all records from which must be extracted from a certain database field

Copy/Paste Table Data

    Copy opened table or query to clipboard
    Paste data from clipboard into an opened table

Encrypt Files

    Encrypt all files from C:\My Templates folder (Database Tour Pro only)