Unit rDBComponents_UDB

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

rDBComponents_UDB (UDB= Universal DataBase) is set of enhanced DB components which can be used instead of standard db components and provide the same properties and functions for different types of databases. It allows to convert application very easilly from one database type to another.

Now it supports following type of database connections and queries: ADO = dbGo (used for MSAccess, MSSQLServer nad other db via ODBC or JET) ZEOS (used for MySQL, Firebird and other supported databases) DBX = dbExpress (used for MySQL, Interbase, Firebird and other supported databases) IB = Interbase (used for Interbase or Firebird) FIB = FIBBlus (used for Interbase or Firebird)

Usage of particular DB type is set by compiler conditional defines: DEFINE USEADO for ADO DEFINE USEZEOS for Zeos DEFINE USEDBX for DBX DEFINE USEIB for Interbase DEFINE USEFIB for FIBBlus DEFINE USEFD for FireDac

Unit contains new data connection components: TConnectionUDB - descendant of TADOConnection/TZConnection/TSQLConnection/TIBDataBase/TpFIBDatabase/TFDConnection TQueryUDB - descendant of TADOQuery/TZQuery/TSimpleDataSet/TIBQuery/TpFIBDataSet/TFDQuery

TQueryUDB provides many new functions and properties usefull for any db application for centralization of all db tasks: - new props (TableName, IdFieldName, FieldTagToDuplic, FieldTagToReadOnly...) - new function (DuplicateRecord, SetFieldsReadOnly - according of fields tag value) - new events for centralized setting of fields captions and properties in application - many new function for setting of SQL commands in runtime

Unit contain set of visible DB components. All of them contain internal TQueryUDB dataset with definable SQL command for loading of list values and events for setting of SQL in run time, so no other auxilary dataset is needed on the form. It can show bounded buttons used for enhanced selection of value or showing details of selected record dependently on application.

TEditUDB - TEdit descendant loads and display text from any SQL command TComboBoxUDB - TrComboBoxEx descendant load list of items from any SQL command TrDBComboBoxUDB - TrDBComboBox descendant load list of items from any SQL command TrDBLookupComboBoxUDB - TrDBLookupComboBox descendant load list of items from any SQL command TListBoxUDB - TListBox descendant load list of items from any SQL command TrDBListBoxUDB - TrDBListBox descendant load list of items from any SQL command TrDBLookupListBoxUDB - TrDBLookupListBox descendant load list of items from any SQL command

TCheckListBoxUDB - TCheckListBox descendant with possibility to load list of items from any SQL command TrDBCheckListBoxUDB - TrDBCheckListBox descendant with possibility to load list of items and values from any SQL command, provide all functions for N:M relationship

TrDBRecViewUDB - TrDBRecView descendant with possibility to load/show/edit record from any SQL command TrDBGrid_MSUDB - TrDBGrid_MS descendant with possibility to load/show/edit records from any SQL command

Overview

Classes, Interfaces, Objects and Records

Name Description
Class TConnectionUDB TConnectionUDB - descendant of TADOConnection/TZConnection/TSQLConnection/TIBDataBase/TpFIBDatabase
Class TQueryUDB TQueryUDB - descendant of TADOQuery/TZQuery/TSimpleDataSet/TIBQuery/TpFIBDataSet
Class TQueryIntList TQueryUDB descendand for internal purpose only
Class TBoundComboButton TSpeedButton descendand for internal purpose only as bounded button
Class TrDBCheckBoxUDB TrDBCheckBox descendand with boolean value 1 and 0
Class TEditUDB TEdit descendant loads and display text from any SQL command
Class TComboBoxUDB TComboBox descendant load list of items from any SQL command
Class TrDBComboBoxUDB TrDBComboBox descendant load list of items from any SQL command
Class TrDBLookupComboBoxUDB TrDBLookupComboBox descendant load list of items from any SQL command
Class TListBoxUDB TListBox descendant load list of items from any SQL command
Class TrDBListBoxUDB TrDBListBox descendant load list of items from any SQL command
Class TrDBLookupListBoxUDB TrDBLookupListBox descendant load list of items from any SQL command
Class TCheckListBoxUDB TCheckListBox descendant with possibility to load list of items from any SQL command
Class TrDBCheckListBoxUDB TrDBCheckListBox descendant with possibility to load list of items and values from any SQL command, provide all functions for N:M relationship
Class TrDBRecViewUDB TrDBRecView descendant with possibility to load/show/edit record from any SQL command
Class TrDBGrid_MSUDB TrDBGrid_MS descendant with possibility to load/show/edit records from any SQL command
Class TrDBGridSorter_UDB  

Functions and Procedures

procedure Register;

Types

TDatasetEventType = (...);
TDatasetEventTypes = set of TDatasetEventType;
TGetSQLEvent = procedure(Sender: TObject; SQL: TStrings) of object;
TClickComboButton = procedure(Sender: TObject; Con: TConnectionUDB; TableName: string; DataField, ListField: TField) of object;
TDataSetEvent = procedure(DataSet: TDataSet; EventType: TDatasetEventType = deNone) of object;

Description

Functions and Procedures

procedure Register;
 

Types

TDatasetEventType = (...);
 
Values
  • deNone:  
  • deBeforeOpen:  
  • deAfterOpen:  
  • deBeforeClose:  
  • deAfterClose:  
  • deBeforePost:  
  • deAfterPost:  
  • deBeforeScroll:  
  • deAfterScroll:  
  • deBeforeCancel:  
  • deAfterCancel:  
  • deBeforeInsert:  
  • deAfterInsert:  
  • deBeforeEdit:  
  • deAfterEdit:  
  • deBeforeDelete:  
  • deAfterDelete:  
  • deBeforeApplyUpdates:  
  • deAfterApplyUpdates:  
  • deAfterPostOrApplyUpdates:  
TDatasetEventTypes = set of TDatasetEventType;
 
TGetSQLEvent = procedure(Sender: TObject; SQL: TStrings) of object;
 
TClickComboButton = procedure(Sender: TObject; Con: TConnectionUDB; TableName: string; DataField, ListField: TField) of object;
 
TDataSetEvent = procedure(DataSet: TDataSet; EventType: TDatasetEventType = deNone) of object;
 

Generated by PasDoc 0.13.0 on 2016-01-23 23:42:46