New Components and Unified SQL Support in Universal Data Access Components 2.50!

Devart news about betas, releases, awards, and other information
Devart Team
Posts: 3176
Joined: Tue 26 Oct 2004 13:51

New Components and Unified SQL Support in Universal Data Access Components 2.50!

Post by Devart » Fri 03 Apr 2009 13:10

Dear users,

Devart is glad to announce the release of UniDAC 2.50 with a bundle of new components and Free Pascal under Linux support that make UniDAC more effective and really universal.

We have added many significant improvements such as:
  • Unified SQL support
    Unified SQL is a language extension that has different constructions and allows to write truly database-independent SQL code. Unified SQL includes:

    Macro - in Unified SQL macros can evaluate to a different value depending on the provider used by the TUniConnection component.

    IF directive - for the purpose of extra flexibility Unified SQL supports conditional inclusion of SQL code

    SQL Function - introduce standard for calling common SQL functions. In run time function is transformed either to the corresponding native function, or to an equivalent expression.

    Literal - provides universal syntax for date, time, and timestamp literals.
  • TUniLoader component
    serves for fast loading of data to the database. For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed. For example, Oracle Direct Path Load interface is used for Oracle.
  • TUniDump component
    serves to store data from tables or editable views as a script and to restore data from a received script.
  • TUniConnection.AssignConnect method
    shares physical connection between several TUniConnection components
  • Support for Free Pascal under Linux
  • DMLRefresh support in the PostgreSQL provider
Try out Universal Data Access Components on its download page.

If you have any suggestions or questions concerning UniDAC, feel free to contact us by e-mail or through the forum.

Devart Development Team