Rosi UDB Components
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) FireDac
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
Updated version compatible with Delphi2010+.
Classes, Interfaces, Objects and Records
Functions and Procedures
Functions and Procedures
Generated by PasDoc 0.13.0 on 2016-06-03 22:13:41