Description

Simple runtime SQL query builder for Delphi.

Informations

• Status: Fully functional
• Source: Included
• Size: 105kB

Platforms: DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8

Description

Library for easy create search, filetrs and orders for DB-programs.

Informations

• Status: Fully functional
• Source: None
• Size: 154kB

Platforms: D7, D6

Description

Help tools for SQL-queries. Save your developing and debuging time. SQL tools for INSERT, UPDATE, SELECT, DELETE, Counters, Parameters (for blobs) queries and more. See demo project for more info.

Informations

• Status: With Nag-Screen
• Source: On purchase/registration
• price: $15
• Source price: $40
• Size: 227kB

Platforms: D6, D7

Description

ORM framewok for Delphi with full support for data manipulation, complex and advanced queries, inheritance, polymorphism, and more...

Features:

• Several database servers supported
• Several database-access components supported
• Multi-platform solution - Win32, Win64, Mac OS X, VCL, FireMonkey
• Saving, updating and loading of entity objects in an object-oriented way
• Queries - Powerful query API using criteria expressions, projections, grouping, conditions and even logical operators in a LINQ-like approach
• Inheritance mapping and polymorphism - map a full class hierarchy into the database
• Cross-database development - use a single Delphi code to target multiple databases in a transparent way
• Choose from classes-to-database approach (creating the database structure from classes) or database-to-classes approach (creating classes source code from database, using TMS Data Modeler)
• Mapping directly in classes using custom attributes
• Association mapping
• Lifetime management of objects using object manager
• Cached and identity-mapped objects
• Automatic database structure generation
• Nullable types support
• Lazy loading for associations and blob fields
• Allows logging of SQL commands
• Allows mapping enumerated types to database values
• Open architecture - easy extendable to use different component sets or database servers.

Supported databases:

• Firebird
• Interbase
• Microsoft SQL Server
• MySQL
• NexusDB
• Oracle
• SQLite
• PostgreSQL
• DB2.

Supported Data-Access components

• dbExpress
• dbGo (ADO)
• Interbase Express (IBX)
• SQLite - Native Support
• AnyDAC
• NexusDB
• SQL-Direct.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $220
• Size: 9 670kB

Platforms: C2k10, D2010, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8

Description

It's a discendent of standard TQuery. It allows to fix the (very) slow method to count result records used in the standard query component: fetch each record from the server and store it on the client, increasing a counter... If you use local DBMS as Paradox or dBase you don't are afflicted by poor performances, but if you use DBMS server as MS SQL Server or Oracle, each time your code call the RecordCount method you assist to HD light flashing, network traffic increasing and a very long response time.

More results are in the query recordset, more problems you have... More time you use the RecordCount method on the same query, more time you have the problem...

TServeCountQuery solve the problem, asking directly to the DBMS the number of records retrieved: fast, easy and clear. You can use this component as a standard TQuery component, all the work is done in background and if some error occours, will be fired an OnCountError event and the standard RecordCount method will be called. You can access too to the LastCountSQL string propery to see the SQL statemant used to retrieve the record count in the current query.

Informations

• Status: Fully functional
• Source: On purchase/registration
• price: $39
• Size: 6kB

Platforms: D5

Description

TxQuery component is a TDataSet descendant component that can be used to query one or more TDataSet descendant components using SQL statements. It is implemented in Delphi 100% source code, no DLL required, because it implements its own SQL syntax parser and SQL engine.

Informations

• Status: Fully functional
• Source: Included
• Size: 911kB

Platforms: D2005, D2006, D2007, D2009, D2010, D7, DXE