|
 |
Component set |
Package contains the following design time components that are placed on dbExpress eXtentsion tab in the development IDE:
| TDBXConnection | encapsulates a dbExpress derived connection to a database server |
| TDBXSQLProcessor | manages generation and parsing of MacroSQL statements |
| TDBXQuery | represents a bidirectional dataset (descendant of dbExpress TSQLQuery) with a resultset that is based on a SQL statement (can be directly linked to TDataSource) |
| TDBXTable | is a dataset component that encapsulates a database table |
| TDBXStoredProc | encapsulates a stored procedure on a database server |
| TDBXUpdateSQL | provides an object for specifying custom data modification SQL statements |
| TDBXDataSet | is a complex component that can be used to operate with table, stored procedure or SQL statement |
| TDBXEvents | represents the global event hanlders for the eXtension components creation and destruction |
|
|
|
|
|
Bidirectional datasets |
DB-Aware visual controls (TDBGrid and others) can be used with a single dbExpress eXtension dataset component such as TDBXQuery, TDBXTable, TDBXStoredProc or TDBXDataSet.
dbExpress eXtension release you from need of utilizing a redundant components chain (TSQLQuery-TDataSetProvider-TClientDataSet) that was the only normal way to display data in a TDBGrid.
Just place one TDBXQuery (TDBXTable, TDBXStoredPorc or TDBXDataSet) and it's all done. |
|
|
|
|
Custom updates |
dbExpress eXtension by means of TDBXUpdateSQL (analogue of well known BDE's UpdateSQL component) provides flexible update approach.
You may choose to apply changes to database by autogenerated SQL statements (default option) or by custom SQL statements defined in TDBXUpdateSQL (UpdateObject in DataSet based components).
This feature allows easily specify particular SQLs which will be executed to apply changes for multi-table join or union select, stored procedure resultset, etc. |
|
|
|
|
Cached updates |
| DataSet components (TDBXQuery, TDBXTable, TDBXStoredProc, TDBXDataSet) can be used in the cached updates mode which is most useful in client-server applications by minimization of network traffic, fewer transactions and shorter transaction times. know more... |
|
|
|
|
Connection pooling |
| Pooling connections can significantly enhance the performance and scalability of your application server or web application by efficient reusing of opened connections. dbExpress eXtension provides connection pooling automatically for your application. You can use the TDBXConnection’s PoolOptions property to control connection pooling behavior. |
|
|
|
|
SQL preprocessor |
SQL preprocessor for MacroSQL embedded in Luxena dbExpress eXtension by means of define, ifdef, else and endif statements allows using of once created SQL query against different databases (ORACLE, MS SQL, Interbase, Informix, MySQL, Sybase, DB2, etc.)
Also with MacroSQL you are able to add debug and any other runtime logic without changing the SQL statement.
MacroSQL brings rapid and simple multi-database development. MacroSQL is provided by TDBXQuery and TDBXUpdateSQL. checkout example... |
|
|
|
|
Registered version |
Registered users receive:
- registered version of product;
- free updates;
- bug fixes;
- e-mail support;
- royalty-free runtime.
|