WHY AQB
For product owners
For end-users
For developers
Blog
Testimonials
About ActiveDBSoft
PRODUCTS
For Developers
FOR DESKTOP
.NET WinForms
.NET WPF
Delphi / C++Builder
Java
ActiveX
FOR WEB
ASP.NET
ONLINE SERVICES
SQL Text Formatter
SQL Query Analyzer
For End-users
FlySpeed SQL Query
A handy too to work with SQL queries and data with a friendly Visual Query Builder
PRICING
RESOURCES
Help center
User's guide
Community forum
.NET Property Reference
Downloads
Sources on GitHub
BLOG
Online Demo
Call Me Back
Sign in
Active Query Builder support area
Search
Knowledge Base
Community Forum
Support tickets
Help Center
Active Query Builder Knowledge Base
Common guide for all editions
41 articles
Common Questions
What are the Syntax and Metadata providers for?
How to read the result SQL query text and load the query back?
How to get formatted SQL text and setup formatting options?
How to validate an SQL query? (SQL syntax checking and validity against a database schema)
How to detect incorrect/unknown object and field names in the query?
See all
9
articles
Designing a user-friendly query building environment
Adding virtual objects and calculated fields to database schema
Defining friendly names for database objects and fields
Customizing the Database Schema Tree structure
Saving queries for further use as datasources in new queries (Reusable queries)
Modification of sub-query text separately from the entire query
SQL Query analysis
Analyze SQL query: Get common information (used objects, fields, output columns)
Analyzing complex SQL query structure (with unions and sub-queries)
Enumeration of output columns in a (sub)query
Enumeration of data sources and joins in a (sub)query
Determination of presence of the INTO clause in a query
SQL Query modification
How to add the "with (nolock)" hint to all datasources in the query?
How to specify the stored procedure parameters programmatically?
How to create a simple query programmatically?
Generation of INSERT, UPDATE, DELETE statements for a given SELECT statement
How to change sorting, add filters, limits and aggregations to the query?
See all
13
articles
Programming Tips and Tricks (all editions)
How to fix the "Internal server error: Could not load file or assembly 'Newtonsoft.Json, Version=6.0.0.0" error?
How to apply filters at runtime on the selected columns in my query
How to add joins to the query on adding a table from the tree?
How to add an object to the query by dragging from external control to the query builder?
How to drag an object from the database schema tree to external control?
Localizing Active Query Builder
Available localizations
Loading and selecting language in run-time
Localizing Active Query Builder for .NET and Java
Localizing Active Query Builder VCL and ActiveX Edition
Confirm