dbQwikEdit Version 2.1

Connect to virtually any database
DBQwikEdit connects to your data using Microsoft's Active Data Objects (ADO). DBQwickEdit can connect directly to any ADO data provider or ODBC via ADO's ODBC data provider. You can easily connect to such databases as:

MS SQL Oracle
Access
FoxPro
Dbase
Paradox
DB2
Excel
MySQL
And many more.

[Top] >DataGrid provides power and simplicity
DBQwikEdit's data grid makes viewing, adding and updating table data as simple as typing.

Data Grid shows you your table data just like a spread sheet, to change data you simply type in the new values, it is that easy!
What about those null values, versus spaces? Spot Null values easily as highlighted cells no more guess work
Sort, and filter your data through the use of simple dialogs to work with subsets of data.
Export your data grid to a host of formats using our powerful export tool.
Move your data grid contents to another table with the powerful Batch Move feature. You can move whole tables, or just your subset of data to new or existing tables, in you current database, or across to another database table.
Create ad hoc reports by printing your grid contents.
Generate SQL from DataGrid to Syntax Builder to take advantage of query builder's advanced SQL features and query saving.

[Top] >View Database Structures
Knowing your table structures can be very important in manipulating data and building efficient and correct SQL. View your table definitions with ease, you can see:

Column Names
Data types
Nullable columns
Data Size
Indexes
Indexed Columns
Primary Indexes

Knowing this information will help you create quality SQL and debug performance and data problems quickly.

[Top] Syntax Builder
For the "big boys" we have Syntax builder. If you know how to write SQL and need to take full control, Syntax Builder is for you. It combines a point and click syntax builder with free format typing to build almost any statement you like. Syntax builder offers:

Point and click syntax building to increase speed and accuracy of building SQL statements.
Customisable syntax pick lists. Add your own favourite clauses to the syntax builder, make this truly a tool fitting your requirements.
able and column pick lists, mean you don't need to remember all the names of your database structures.
Included tables pick list make life even easier by tracking and making a "short list" of tables included in your query.
Syntax highlighting help you read your SQL and spot mistakes more easily.
Save SQL to files and open again any time, no need to rebuild statements.
SQL history, uses a browser-like forward / backward navigating of your session's SQL statements. Recall older statements to execute, or save to file if it is a "keeper".
Export selected data to a variety of formats using our Data Export.
Export selected data making on-the-fly reports. Combine this with query save and you can create libraries of ad-hoc reports.
Use Data Grid or Visual Query Builder to generate SQL into SQL Builder as a starting point or to access other Syntax Builder features.

[Top] Visual Query Builder
DBQwikEdit visual query builder is a tool for all. It's simplicity and power will benefit the novice as well as the expert. Build queries across multiple tables using a visual interface.

Drag and drop tables into the query.

Check the columns you want

Assign table aliases

Join tables by dragging and dropping fields

Join properties control outer joins

Add filters on columns

Add sorts to the query.

Run your query directly.

Generate SQL to Syntax Builder for modification / Saving.

[Top] Data Mover
DBQwikEdit's Data Mover is a real time saver in managing your data. It can assist in populating data across databases as well as migrating data between schemas. With the Data Mover:

Move data between tables of the same or different databases.
Move either whole tables or subsets of data using Data Grid.
Field mapping allows schema name changes.
Move only selected columns.
Dynamically create new tables as the destination.
This tool has so many uses, you will wonder how you ever managed without it.

[Top] Data Exporter
QBQwikEdit data exporter is a unique feature adding to your ability to manage and manipulate your data. Data Exporter will save your data to a multitude of formats unlocking the restrictions placed on you by your database manager. With Data Exporter you can: · Save the results of virtually any query or table to a file.

Export to:
HTML Files
XML Files
Comma delimited Files
Text Files
SQL statement files.
Windows Clipboard
MS Excel
MS Word
RTF (Rich text format).
DIF
SYLK
LaTeX files
Select your data a produce a file of data with ease.
Use your database to produce web pages.

The power and ease of use will amaze you.

Sample HTML Export

[Top] Features Comparison

Features

Lite

Pro

Read Only Mode
Yes

Yes

Table List Filter
Yes

Yes

Table Fields View
Yes

Yes

Data Editor
Yes

Yes

Data Schema Info
Yes

Yes

Data Editor QuickSort
Yes

Yes

Data Editor QuickColumns
Yes

Yes

Data Editor Column Autosize
Yes

Yes

Data Editor SQL Generator
Yes

Yes

ADO Data Sources
Yes

Yes

Data Editor Data Exporter
Yes

Yes

Data Export Format HTML
Yes

Yes

Data Export Format XML
No

Yes

Data Export Format CSV (Comma Delimited)
Yes

Yes

Data Export Format Text File
Yes

Yes

Data Export Format SQL
No

Yes

Data Export Format Clipboard
Yes

Yes

Data Export Format MS Excel
No

Yes

Data Export Format Ms Word
Yes

Yes

Data Export Format RTF
Yes

Yes

Data Export Format DIF
Yes

Yes

Data Export Format SYLK
No

Yes

Data Export Format LaTex
No

Yes

Data Export Format DBF
No

Yes

Data Mover
No

Yes

Data Editor Print
Yes

Yes

SQL Builder
Yes

Yes

SQL Builder Customizable Keywords
Yes

Yes

SQL Builder History Browser
Yes

Yes

QSL Builder Query Save/Open
Yes

Yes

SQL Builder Data Print
Yes

Yes

SQL Builder Data Export
No

Yes

SQL Builder Data Column Autosize
Yes

Yes

SQL Builder Syntax Highlighting
Yes

Yes

Visual Query Builder
Yes

Yes

Visual Query SQL Builder SQL Gen
No

Yes

Visual Query Data Export (via SQL Builder)
No

Yes

Visual Query Sort
5

Yes

Visual Query Filter
5

Yes

Visual Query SQL Generator
No

Yes

Visual Query Join Syntax Generator
Yes

Yes

Visual Query Smart Icons
Yes

Yes

Integrated ADO Admin
Yes

Yes

Integrated ODBC Admin
Yes

Yes

Null Highlighting
Yes

Yes

Inner Join/Outer Join
No

Yes

Execute StoredProc
No

Yes

[Top]