SQL Query Builder for Delphi Visual SQL Query Designer for Delphi and C Builder. Active Query Builder VCL Edition is a visual query builder component suite that allows your end-users to build SQL queries with unions and sub-queries via an intuitive visual interface.
Universal Database Query ToolIf you are looking for a proper tool to work with data and SQL queries with an ad-hoc visual query builder, you've got to a look at FlySpeed SQL Query. This Windows app connects to all modern database servers and works with all popular desktop databases and office file formats (CSV, Excel). With FlySpeed SQL Query you can browse and edit data in grid form or via the customizable form view, quickly find and filter data, and set up master-detail views, so dealing with data will be a pleasure. Ad-hoc SQL Query Designer. Product summary Latest version: 3.7.9.6Price from: Free / $ 39The visual query designer lets you create new SQL queries by drag'n'drop, and represent off-the-shelf queries visually. It makes SQL query analysis, creation, and modification much simpler. Using FlySpeed SQL Query, you can build parameterized queries, and browse data from linked tables via foreign keys.Your queries will be saved along with the database connection right beside the database object tree, so you'll be able to continue your work from the point where you stopped last time.
The history of SQL query execution is saved automatically; all the settings used during your last session will be restored the next time you start FlySpeed SQL Query. Free SQL Query Tool for everyday useThe Free version provides a full-featured workplace for working with SQL queries and browsing the result data.The Full version lets you save time and finish the job in seconds by exporting data to many popular office formats, print, and save reports in PDF. The Free version of FlySpeed SQL Query is fully functional, except the ability to print and export data.It can be used for non-commercial purposes for an unlimited time or evaluated for commercial purposes for 30 days.The special Portable version will allow you to keep your database connection settings and queries at your fingertips.
Install FlySpeed SQL Query to your cloud folder, network or portable drive and get access to your data and settings from all of your workstations.Handy for professionals and a must-have to newbies, FlySpeed Database Query Tools are the best choice to make your work with data and SQL queries more productive than ever before! Availability FlySpeed SQL Query is available in the following versions.
Save 10% ordering this product in discounts:
- Quick backup and Cloud services
- Compression and encryption of backup files
- A set of regular database maintenance tasks and much more
- 30 days free trial
- 25%OFF coupon - 'Torrynet' (valid till 1 March 2020)
By Active Database Software.
Commercial 11 Oct 2017Description
Active Query Builder is a visual SQL query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.- Completely visual building of complex SQL queries: Each union and sub-query has its own working area where it could be built visually as easy a single query.
- MS Access style visual query building UI: The interface is similar to either MS Access query construction interface, but is much more powerful compared to other similar components.
- User-friendly interface with drag & drop support. Complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.
- Powerful means of working with parameters: Active Query Builder can get various information about parsed query like lists of tables and fields used in the query. You can learn parameter names and data types, and discover to what database objects and fields they related to.
- Working in offline mode: In case direct connection to the database is not possible, save database schema to XML file in advance, then load metadata from this file.
- Limiting access to unwanted objects: Deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. You can also check your queries on the presence of unwanted objects before their execution.
- User-friendly query building environment: Active Query Builder allows for substitution of the user-friendly aliases for unintelligible names of your DB tables and fields. Though, your end-users can still build SQL scripts by hand: all the aliases used in query text will be automatically replaced with the real names in the result query text.
- Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite, Teradata, Netezza and ANSI SQL/92, 89 and 2003 dialects SQL syntax. Using Active Query Builder you can determine the currently used database server automatically.
- SQL Formatter: Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.
- Localization: It is possible to localize Active Query Builder completely and to switch between available languages in run-time. Dozens of localizations are ready to use.
The Professional version additionally includes the Advanced SQL Text Editor with code completion and syntax highlighting.
Active Query Builder - is all that you need to work with SQL queries.
Informations
- Status: Partially restricted
- Source: On purchase/registration
- price: $195
- Source price: $395
- Size: 79 135kB
Platforms:C2k10, C2k6, C2k7, C2k9, CB5, CB6, CB64, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, CX, CX.1, CX.2, D2005, D2006, D2007, D2009, D2010, D5, D6, D7, DX, DX.1, DX.2, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64, DXE7, DXE8
Description
Advanced Query Builder is a powerful component suite for Borland Delphi and C++ Builder intended for visual building SQL statements for the SELECT, INSERT, UPDATE and DELETE clauses. It allows you to build new queries visually and/or graphically represent the existing queries in your own applications. The suite includes components for working with standard SQL, MS SQL, InterBase/FireBird, MySQL, PostgreSQL and many more dialects. Advanced Query Builder enables users to make up large and complicated SQL queries with unions and subqueries for different servers without any knowledge of the SQL syntax. Key Features:
- Standard SQL, InterBase/Firebird, MySQL, PostgreSQL, Oracle, DB2 and DBISAM support;
- Detailed help system and a demo application for a quicker mastering of the product;
- Powerful component and property editors, which allow to set easily many query building parameters at the design-time;
- Creation of queries with unions and subqueries;
- High productivity even on slow computers;
- Powerful SQL parser, which allows you to represent complicate SQL statements visually;
- Possibility of creating TxxxQueryBuilder components easily for working with the chosen server;
- Full customization of font colors, object appearance, etc.
Informations
- Status: With Nag-Screen
- Source: On purchase/registration
- price: $195
- Size: 16 157kB
Platforms:C2k10, C2k6, C2k7, C2k9, CB5, CB6, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, CX, D2005, D2006, D2007, D2009, D2010, D5, D6, D7, DX, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8
Description
FastQueryBuilder is an easy-to-use visual SQL query builder. It works with local and client-server databases.You can use FastQueryBuilder in your applications written in Borland Delphi or Borland C++Builder to create simple SQL generators.
FastQueryBuilder enables you to work with local and client-server databases using BDE. It also allows you to work with other instead of mathematical symbols), field values can be replaced with descriptions (e.g. 'MasterCard' instead of actual values like 'MC') that makes interface more friendly. Users describe requests by creating their native language sentences and receive the results.
Easy Query builds SQL SELECT statement according to user's demand and database structure you define. It can build SELECT statements with sub-queries, with table aliases, with all kind of joins. If you need a powerful Query Builder in your application - Easy Query is your choice. If you need a filter component with user friendly interface and ability to build sophisticated filters - use Easy Query for it. If you use ADO, ODBC Express, DBISAM, etc. instead of BDE - it is not a problem because we have a lot of BDE Alternatives support components and technology to create a new BDE Alternative support component in several minutes. If your users don't know English - it is not a problem - all interface elements are easy translatable into other languages.
Informations
- Status: Trial (work while IDE is running)
- Source: On purchase/registration
- price: $129
- Source price: $199
- Size: 18 213kB
Platforms:C2k10, C2k6, C2k7, C2k9, CB6, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D2005, D2006, D2007, D2009, D2010, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8
Description
This control will execute both QBE and SQL queries.Informations
- Status: Fully functional
- Source: Included
- Size: 7kB
Platforms:D1, D2
Description
Query Studio provides an easy way to give users access to powerful queries without requiring any knowledge about SQL. Users can setup complex queries in an almost natural language way with Query Studio. Dropping the component VisualQuery on the form and connect to the database opens the visual query power of Query Studio.Feature details:
- Visual definition of SQL, in a natural language-like way
- Localization support to easily translate all user interface elements
- Allows definition of source tables and joins
- Allows definition of order and filtering
- Exclusive parameter editors feature: a value in the filter condition can be attached to a parameter editor. End-user can change editor value and it will automatically be reflected in SQL
- Supports SQL syntax for Microsoft Access, Microsoft SQL Server, AnyDAC, Oracle, MySQL, Nexus, Interbase, DBISAM and Local BDE
- Automatically set TDataset properties. Supports BDE, ADO, AnyDAC, IBX, DBISAM, Nexus, IBO, DirectSQL and DBExpress dataset descendants
- Automatic grouping feature for aggregate functions usage
- Support custom field expressions and custom filter conditions.
Informations
- Status: Trial (work while IDE is running)
- Source: On purchase/registration
- price: $85
- Size: 3 345kB
Platforms:C2k7, D2007, C2k9, D2009, C2k10, D2010, D7, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8
Description
Away to standtartizes your application by having one form from witch you can select one or more records from any table. It's main use is to provide way to let user chose from LookUp tables.No need to write form for it - form included. Just put the component of any DataModule (or form), point to Database and write SQL statement. Then use Execute method and get the result in RxLib MemoryData Table.
RxLib required.
Informations
- Status: Fully functional
- Source: Included
- Size: 49kB
Platforms:D4, D5
Description
Component for visual creation of SQL-queries. Enables the user to create SQL-queries by simply putting together English sentences with the mouse. The following languages are also supported: Norwegian, Spanish, French and German.The main new feature of TQuickSelect is the ability to access queries (reports) without having to execute the dialog. A new component (with full source) is included as an example. If you want to take a look on a full overview of new features, visit the TQuickSelect homepage.
Informations
- Status: Fully functional
- Source: On purchase/registration
- Source price: $45
- Size: 154kB
Platforms:D2, D3, D4, D5
Description
Visual Query Builder component to generate and even run multi-database SQL queries. Works equally well with server based SQL and Borland's local SQL. Built-in Query wizard answers your user's requests for adhoc queries with as little as one line of code. Registered users also receive a developers sql property editor version for their own use, help files and full source code. The foundation component and code need by all Delphi database developers. Delphi Choice 96 Award Winner.Informations
- Status: Trial (work while IDE is running)
- Source: N/A
- price: $55
- Size: 141kB
Platforms:D2, D3, D4, D5, D6, D1
By Viktor Ismagilov.
Freeware + source 11 Mar 2004Description
This component allows you to build quries in your applications. It is very similar to MS Access Visual Query Builder. Now support two DBEngines: IBX and BDE. Number of Engines will be Extended in future versions.Informations
- Status: Fully functional
- Source: Included
- Size: 203kB
Platforms:D6, D7