Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 19440, Complete Application Using Employee Database with ADOExpress

by Marcio Borges Email: marciowb@gmail.com


A complete application using Employee database shipped with Interbase.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For InterBase, Version 6.0  to 7.0 2038 downloads
Copyright: Open Source or other


Size: 1,623,442 bytes
Updated on Mon, 03 Feb 2003 15:17:04 GMT
Originally uploaded on Mon, 06 Jan 2003 01:25:32 GMT
SHA1 Hash: 1911B865B02C6717530EE41044F52C236C48A46D
MD5 Hash: 5234784D15F9B3A3B90F15DD2E7FDAC0

    Explore the files in this upload

Description
A lot of people ask us how to develop applications using Interbase and ADOExpress. This application is to be used as a guide for these people.

Various techniques are shown, like: blob manipulation (images, sound and memo), array fields, DDL use for database update, several properties are showing, charts, reports, filter etc.

It is a good guide to develop applications using Interbase+ADOExpress. It uses SIBPROvider like Interbase OLE DB provider, but with few (or a lot!) modifications, you are able to run it with other OLE DB providers.

This version has the following features:

1.01a 2003-01-10:
* (new) Creating a new Database using only ADO;
* (new) Populating an ImageList with images from blob fields;
* (new) Populating ComboBox and showing images;
* (new) Using ADO and Decision Cube components to build usefull Charts;
* (new) Resize an image to fitch into a rect
* (new) Customizing painting in a ComboBox with images and text
* (new) Painting a text centralizing vertically

1.00a 2003-01-05:
* Using DSO to bind a recordset from a TADOQuery to HTML table element (like dbgrid);
* Build html and view it in Delphi forms (like a report) with a result set from a recordset of a
TADOQuery;
* Upgradding database schema (add/change columns, triggers, procedures, views);
* Configuring database connection string;
* Check if connection string is valid, otherwise ask user to configure connection string
* Testing a connection string;
* Getting connetion status (ask if server is alive);
* Working with transactions;
* Using SIBPROvider command/recordset custom properties;
* Getting the generator value assigned by server
* Using reports (DBGrid, HTML, QuickReport) with ADO;
* Use DBGrid to show simple reports;
* Updating a blob field with a image;
* Loading a resource and saving it to a blob field;
* Saving a stream to a blob field;
* Converting GIF to Bitmap;
* Converting Bitmap to GIF;
* Using sophisticated interfaces with end user, for edit, insert, delete, filter, find and view;
* How to use simple interfaces with no code or few lines of code to edit, insert, delete and
navigate records from a table;
* Feature full interfaces for edit and insert records;
* Get and show values from array fields;
* Editing and inserting data in tables with foreigners keys composed.
* Geting and displaying images from blob field;
* Geting and updating blob fields with sounds and music;
* Exporting bitmap files from a blob field;
* Finding records;
* Filtering records;
* Refreshing data;
* Assigning recordsets to TADOQuery;
* Loading and saving form or application state;
* Accessing TWebBrowser HTML DOM elements from Delphi;
* Using DBChart;
* Exporting chart images;
* Building complex and rich chart reports with SIBPROvider;
* Access Connection or Command or Recordset or Field properties from Delphi;
* Populating a ImageList with images from blob fields;
* Populating ComboBox and showing images;
* Using ADO and Decision Cube components to build usefull Charts;
* Resize an image to fitch into a rect
* Customizing painting in a ComboBox with images and text
* Painting a text centralizing verticaly

To be demonstrated in the next versions:

* Handle Interbase/Firebird error codes from ADO;
* Intercepting OLE DB/ADO multi errors;
* How to use ADO Data Shapping with TADOQuery;
* Using Data Shapping with elaborated Charts;

You can download SIBPROvider at: http://codecentral.borland.com/codecentral/ccweb.exe/edit?id=16723

For more information, see http://www.sibprovider.com

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03