Database Tour
Documentation
Contents
General Topics
Overview
Editions
Special Requirements
64-bit vs 32-bit
How to start
Version History
How to Register
Working with Databases
Creating Databases
Opening Data Source
Closing Data Source
Registered Databases
Database Objects
Database Objects' DDL
Search for Database Objects
Database Objects' Descriptions
Database Structure Tree
Exporting Database Structure to DBML Format
Working with Database Sessions
Working with Database Transactions
Dragging / Importing Files
Working with Tables and Queries
Creating Tables
Creating Schema for a Text Table
Working with Table and Query Data
Working with Tables
Working with SQL Queries
Filtering Data
Sorting Data
Searching and Replacing Text
Working with Current Row
Working with Current Column
Database Grids
Using Clipboard
Data View
Conditional Formatting
Table Service Functions
Viewing and Editing Table Structure
Adding or Modifying Table Field
Adding Table Index
Adding Table Constraint
Adding Table Foreign Key
Adding Table Partition
Deleting Database Tables
Renaming Database Tables
Packing Database Tables
Managing Passwords for Paradox Tables
Exporting / Importing Data
Exporting Data
Available Export Formats and Format Specific Options
Text or CSV
JSON
Excel (XLS)
Excel (XLSX)
Excel (XML-based)
HTML
XML
dBase
RTF
PDF
SYLK
Excel (OLE)
Word (OLE)
SQL Script
Database
Custom
Table and Field Mappings
Export Logs and Error Handling
Exporting Large Datasets
Exporting Average Datasets
Improving Data Exporting Performance
Exporting to HTML Using Template
Importing Data
Duplicating Tables
Copying Data to Clipboard
Working with Fields
Blob Fields (Memo, Graphic)
Data Aggregation Functions
Batch Operations with Text Fields
Batch Changing Field Values
Command Line Usage
Open a Single File
Export / Import Data
Open a Database
Batch Operations with Text Fields
BDE Utilities
Encrypt / Decrypt a File
Options
Environment
BDE Language Drivers
Creating and Configuring BDE Aliases
BDE Configuration
File Associations
Reports and Printing Data
Printing Data
Reports Overview
Creating Reports
Report Builder
Working with Report Template
Report objects
Groups in Reports
Building Expressions
Exporting Report to File
Additional Tools
Command Line Generation
Encrypting / Decrypting Files
Database Specific Tools
SQLite Tools
Microsoft Access Tools
Firebird Tools
Interbase Tools
Examples
Queries
Filters
ADO Connection Strings
Expressions
Example of a .bat File
Typical Tasks Solutions
Examples of Batch Changing Field Data
Copy or Export Data to Clipboard
Copy Table to Another Database
Export Data to JSON
Export Selected Columns
Export Data to HTML with Totals
Using Template in HTML Export
Export Data from DBF to Paradox
Export Data from Excel to SQLite
Convert Data from Paradox to Firebird
Migrate Data from SQL Server to Oracle
Migrate Tables from PostgreSQL to SQL Server
Import Data from the Same Database
Synchronize Data between Two Databases
Copy Full Dataset to Clipboard
Paste Data from Clipboard to Table
Delete Database Records
Specify Custom Column Titles
Specify Column Pick List
Get the Sum of Numeric Field
Find and Replace Data in Examples
Print a Dataset
Print Selected Columns
Print a Dataset with Totals
Create Report with Grouping
Automate Report Loading
Drop All Views in a Database
Export Stored Procedures from Firebird Database to a SQL Script
Manage Cron Jobs in PostgreSQL Database
Encrypt All Files in a Folder
Appendices
Expression Engine
dataset_row_number
dataset_group_number
dataset_field_val
dataset_field_hex_val
dataset_field_is_null
dataset_nvl
dataset_field_exists
dataset_param_val
query_res
dbnull
dataset_row_count
dataset_min
dataset_max
dataset_sum
dataset_avg
dataset_count
dataset_row_count_ex
dataset_min_ex
dataset_max_ex
dataset_sum_ex
dataset_avg_ex
dataset_count_ex
abs
frac
int
round
sqrt
power
exp
ln
cos
sin
tan
atan
date
time
date_time
add_date_time
compare_date_time
date_time_diff
format_date_time
doc_title
target_file_name
file_created
file_last_modified
file_last_accessed
file_size
file_version
extract_file_ext
extract_file_name
extract_file_dir
extract_file_path
extract_file_text
file_exists
dir_exists
to_number
to_string
format_float
lpad
rpad
iif
upper
lower
capitalize
pretty
length
pos
substr
substr_count
trim
trim_left
trim_right
string_replace
concat
rgb
ordinal_number
quantitative_numeral
number_to_words
parse
char
report_author
report_changed_by
report_database_name
report_dataset_name
report_description
report_file_name
page_left_margin
page_right_margin
page_top_margin
page_bottom_margin
page_number
page_count
page_height
page_width
internal_property
Main Window Shortcut Keystrokes
Database Grids Shortcut Keystrokes
SQL Editor Shortcut Keystrokes
Report Warnings
Error Messages
Migrating Application to Another Machine
Ways of Opening Diferent Data Source Types
Microsoft Access Databases (.mdb)
Microsoft Access 2007+ Databases (.accdb)
Microsoft Excel Workbooks (.xls)
Microsoft Excel 2007+ Workbooks (.xlsx, .xlsb, .xlsm)
HTML Files (.htm, .html)
Firebird Databases (.fdb)
Interbase Databases (.gdb, .ib)
UDL Files (.udl)
dBase Files (.dbf)
FoxPro Files (.dbf)
Visual FoxPro Databases (.dbc)
Paradox Files (.db)
Text and CSV Files (.txt, .csv)
Lotus Files (.wj2, .wk1)
XML Files (.xml)
Oracle
SQL Server
Sybase
SQL Anywhere (Adaptive Server Anywhere)
Informix
DB2
Ingres
Pervasive PSQL
SQLBase
MySQL
PostgreSQL
SQLite
Database Tour Specific File Types
Action File
Column Definitions File
Report File
Field Mappings File
Table Mappings File
Export Definitions File
Repository of Report Objects and Properties
Objects
Report
Data Source
Page
Band
Label
Database Text
File Text
Expression
Image
Database Image
File Image
File Icon
Checkbox
Database Checkbox
Shape
Object Properties
Aggregation Range
Align Horizontally
Align to Container
Align Vertically
Author
Auto Sizing
Auto Stretching
Background Color
Brush
Center
Changed by
Checked
Clear Margings
Column Space
Columns
Condition FALSE
Condition TRUE
Data Source
Data Type
Database Field
Description
Display Mask
Document Title
Duplex Mode
Engine Version
Expression
File Name
Filter
Font
Force New Page
Format
Frame
Global Variables
Grouping Expression
Height
Hide Zeros
Highlight Background Color
Highlight Condition
Highlight Font
Hyperlink
Icon Index
Left
Margins
Name
Number of Copies
On First Page
On Last Page
On Print
Orientation
Paper Size
Paper Source
Pen
Picture
Printer
Records Per Page
Select Printer
Shape
Sort Order
Stretch
Stretch to Align Bottoms
Text
Text Offset
Text Orientation Angle
Top
Transparent
Visible
Width
Word Wrapping
Copyright (C) 2024 Vitalii Levchenko Software. All rights reserved.