|
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:
|
For InterBase, Version 6.0
to 7.0
2049 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
|
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
|
Connect with Us