|
Jetpack
 |
 |
Product Overview
Jetpack is a collection of ActiveX controls designed to enhance any COM
based development language with minimal effort and very little coding. Database developers can use the Jetpack controls to build a
client application using whatever languages and tools they are most familiar with, including Microsoft Visual Basic, Visual C++, Visual
J++, Borland Delphi, Powersoft Powerbuilder, and Micro Focus Object Cobol.
Jetpack control's are designed to be highly functional. For example, adding the Table Design control to
your form at design time and a single line of code gives you all the functionality needed to create or modify a Jet database table
including fields, indexes, properties and attributes. Adding the Queryer control to an application and setting a couple of properties,
gives you a fully- featured visual ad-hoc querying tool that allows users to interrogate a wide range of data sources without any
knowledge of SQL.
The Jetpack control is a multiple control comprising 11 different controls. Each control is considered to
be a 'light-weight' ocx control that can be added individually to your application as needed. The bulk of the code in Jetpack is shared
by the controls - this avoids a lot of duplicated code. Alternatively the individual controls in Jetpack can be purchased separately. As
individual controls they have a smaller memory footprint. The table below illustrates how the Jetpack
controls are packaged and sold.
|
|
Features
|
 |
 Design
With Table Design you can create tables, and make changes to an existing table even after it has been implemented. Its
interface allows you to easily view, edit or create fields and indexes. Indexes based on a single field or on multiple fields is
supported. Data in existing tables is preserved (if possible) even when renaming, modifying or copying a field. |
|
|
 |
 Export
(JET + OLEDB)
Export copies a table's structure as well as its data to another database.
Export Jet can export data to the following database types (requires ISAM or ODBC drivers to be
installed):
Jet Engine databases
dBase (III, IV and V databases
Paradox 3.x, 4.x and 5.x databases
Excel 3.0, 4.0, 95 and 97 spreadsheets
HTML files
Text files
ODBC Remote databases such as Microsoft SQL Server, Sybase SQL Server, ORACLE Server, and Ingres Server.
Any other Installable ISAM database.
Export OLEDB can export to any OLEDB provider. |
|
|
 |
 Find/Findx
(JET + OLEDB) Find adds a powerful search
capability to any database application. The find control only needs to be connected to a data control to allow searching for the first,
previous, next and last record that meets a search criteria. The search pattern can also include wildcards such as *, ?, and [].
There are actually two separate find controls. One is a find dialog window that is loaded at run time and floats on top of an
application, the other is a usercontrol that is added to a form at design time. Find Jet is bound to the Microsoft Data Control. Find
OLEDB is bound to the Microsoft ADO Data Control. |
|
|
 |
 Import
Lets you copy data from an external database into your database. If you are importing a table Import copies the table's
structure as well as the data from the other database. If you are importing a query Import copies the query’s SQL statement from the
other database.
You can import data from the following database types (requires ISAM or ODBC drivers to be installed):
Jet Engine databases
dBase (III, IV and V databases
Paradox 3.x, 4.x and 5.x databases
Excel 3.0, 4.0, 95 and 97 spreadsheets
Text files
ODBC Remote databases such as Microsoft SQL Server, Sybase SQL Server, ORACLE Server, and Ingres Server.
Any other Installable ISAM database. |
|
|
 |
 Maint
Maint is an essential addition to any Jet database application. It allows you to backup, restore, repair, compact, and
convert any Microsoft Jet database. For those large databases, backup can span multiple floppies.
This handy tool is also available as an award winning standalone application, dBMaint, and is also very
useful as a command-line driven utility. Best of all it is FREE! |
|
|
|
 Organiser
Organiser allows you to easily manage the objects contained in a database. Tables and queries (if the database supports
queries) for two databases are displayed alongside each other in a split screen.
With Organiser you can import or export a table from one database to another - the data is automatically converted. Database types
supported include: Microsoft Access, Excel, dBase, Paradox, Text, SQL Server and many more. In fact any ISAM or ODBC database for which
you have a driver.This handy tool is also available as an award winning standalone application, dBOrganiser, |
|
|
 |
 Queryer/Queryerx
(JET + OLEDB)
Queryer is a powerful ad-hoc query design tool allowing users to build complex SQL
statements with a few clicks of the mouse.
It allows you to instantly view the results of your query both as an SQL statement and as a table of results. When you are happy with
your query the SQL is passed back to your application.
Queryer Jet works with any Jet, ISAM or ODBC database. Queryer OLEDB works with any OLEDB provider.
There are actually two separate Queryer controls. One is a dialog window that is loaded at run time, the other is a usercontrol that is
added to a form at design time. |
|
|
 |
 Report
Report adds a simple data reporting capability to any database application. The report control can be bound to a Data control, an SQL
statement, DBGrid, and TDBGrid.
Connecting to a grid control allows you to use the grid's customising features to move, hide and resize columns and rows, to determine
the final layout of a report before printing. |
|
|
 |
 Zoom
Data Zoom adds an instant record maintenance form to your application. It can be bound to a datacontrol or an SQL
statement. The SQL statement can specify an existing table or query.
In addition to the standard maintenance functions of delete, copy, add and modify, Data Zoom fully
supports OLE objects, such as Office documents and graphics, and Hyperlink data types.
Whilst OLE objects allow you to store a wide range of data formats within your database, hyperlinks provide a link to an external source
of data. Examples of hyperlinks might be a persons home page on the internet, an email address, a bookmark in a Word document, a table
in another database, etc. |
|
|
|
Jetpack Packaging |
|
Jetpack is packaged in a number of ways:
- Jetpack Professional: Comprises Jetpack and all of the standalone controls.
This provides for maximum flexibility when deploying these controls across a number of applications. Use the standalone controls
when adding just one or two controls to your program, and use Jetpack when adding several. Jetpack Professional is heavily
discounted and represents great savings when purchasing all of our controls. It includes all Jet and OLEDB versions.
- Jetpack: A multiple ActiveX control comprising the following 11 controls:
Design, Export, Find, Findx, Import, Maint, Organiser, Queryer, Queryerx, Report and Zoom. If you are using several Jetpack
controls in your application this is the best solution. It provides a performance improvement for your programs as each control
shares code that is resident in memory in one single file. It offers an economical alternative as you are effectively getting all 11
controls for 50% of the cost if each control were purchased separately. The Jetpack control does not support OLEDB.
- Standalone: Separate controls with no shared code. If you are only adding
one or two controls from the Jetpack range to your applications you can save money by purchasing only those controls you need.
Queryer, Queryerx, Find, Findx and Export are available as Jet (v6.1) and OLEDB (v6.2).
|
|
| JETPACK CONTROL |
FILENAME |
Approx. SIZE(Kb) |
Jetpack
(includes Design, Export, Find, Findx, Import, Maint, Organiser, Queryer, Queryerx, Report and Zoom) |
Jetpack6.ocx |
2423 |
|
|
|
| STANDALONE CONTROLS |
FILENAME |
SIZE(Kb) |
| Design |
cxdesgn.ocx |
368 |
| Export (Jet + OLEDB) |
cxexprt.ocx |
316 |
| Find (Jet + OLEDB) |
cxfind.ocx |
128 |
| Findx Usercontrol (Jet + OLEDB) |
cxfindx.ocx |
100 |
| Import |
cximprt.ocx |
284 |
| Maint |
cxmaint.ocx |
264 |
| Organiser |
cxdborg.ocx |
336 |
| Queryer (Jet + OLEDB) |
cxqryer.ocx |
512 |
| Queryerx Usercontrol (Jet + OLEDB) |
cxqryrx.ocx |
472 |
| Report |
cxreprt.ocx |
328 |
| Zoom |
cxzoom.ocx |
360 |
|
|
|
NOTE:
1. The evaluation versions of the above products are slightly larger in size, but identical in functionality.
2. The OLEDB versions of the standalone controls: cxfindx.ocx and cxqryrx.ocx are included in the Jetpack evaluation download
but are purchased separately. |
|
|
Technical Support
Registered owners of Jetpack have access to free email support from Chisel Software with a guaranteed
response in one business day. Product updates, sample programs, and answers to frequently asked questions are freely available from
Chisel Software's web site.
Sometimes customers want a dedicated account manager to help solve technical problems. The Premier
Support Plan offers a flexible and affordable priority assistance program suitable for companies of all sizes.
Premier support contract purchasers receive direct access to the developers at Chisel Software. This
includes 24-hour, 7-day per week support for urgent issues.
|
|
Download Page
To download the latest update, a demonstration, or evaluation copy of Jetpack,
click here.
|
|
