473,574 Members | 2,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual Query Builder with unions and sub-queries

I am glad to present to the community of this group the new version of
our component intended for visual building of SQL queries via an
intuitive interface - Active Query Builder
(http://www.activequerybuilder.com/). It has full support for MS SQL
Server dialect starting from version 7 to 2005.

Active Query Builder can be used in different development environments.
Today our visual component is availiable in the following editions:
ActiveX Edition (.Net-ready COM/ActiveX control) and VCL Edition
(Borland Delphi and C++ Builder component).

It differs from the rest of the components by its the powerful
graphical engine that allows you to build queries visually involving
unions, nested joins and sub-queries. Working with Active SQL Query
builder you can access each union and subquery in one-touch; 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.

The interface of Active SQL Query Builder for Delphi is similar to
either MS-Access or SQL Server visual query construction interface, but
is much more powerful compared to other similar components. The
component may be integrated into your application written in almost any
language with just few lines of code. Active Query Builder is shipped
with detailed help system and easy-to-understand demo application to
help you minimize the learning curve.

You can download the Free edition of our component as well as compiled
demo application from the download page at

Thank you for your attention.

Merry Christmas!

Dec 27 '05 #1
0 1991

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Chris | last post by:
I am just beginning programming again and need a bit of advice. I have both Visual C++ 6.0 Standard Edition and Borland C++ Builder 6. Of these two which do you consider the best for programming windows programs (not the DOS style program). I have had a quick look at both of these and Borland seems to have a lot more components (Buttons, Forms...
by: NAJH | last post by:
I've been trying to do a union with a subquery - I've made a different example which follows the same principles as follows: First bit brings back accounts which are in the top 10 to 15 by account name. Second bit brings back accounts which are in the bottom 10 to 15 by account name. I want to union the two result sets together. These...
by: Neil Zanella | last post by:
Hello, I would like to know whether the following C fragment is legal in standard C and behaves as intended under conforming implementations... union foo { char c; double d; };
by: Bob | last post by:
Trying to use VBisual web developer express 2005 beta 2. Dragged an accessdatasource to the blank web page. Started to configure. Entered location of an access database. On next page, clicked on Query builder. Got error with "Microsoft Visual Studio" in the title - I am using VWD express 2005 beta 2 although I also have Visual Studio 2003...
by: teddysnips | last post by:
I have to write an application to do some data cleansing. It's a Contact database, but over a number of years there are multiple companies which are all essentially the same entity. For each company there are also multiple contacts, some of which may be congruent. It's a very simple app. with only two forms. The first form shows two...
by: Farshid | last post by:
Hi Is there any way to use Visual Studio Query Builder in Windows Forms applications. I think query builder dialog is in Micosoft.VSDesigner assembly but i dont know how to use it. Thank You for your help
by: EJO | last post by:
In the query builder, I can create a query that will take a date/time as criteria, and the query finds the records: SELECT SRSrvcsEquip.Stock, SRSrvcsEquip.Activity, SRSrvcsEquip.EquipOwned, SRSrvcsEquip.Manufacturer, SRSrvcsEquip.EHSN, SRSrvcsEquip.Qty, SRSrvcsEquip.PartNumber, SRSrvcsEquip.Description, SRSrvcsEquip.ListType,...
by: FrozenDude | last post by:
Does anyone know of or have a favourite 3rd party Visual Query Builder? We are looking for a very easy to use interface that provides SQL code verification, table joins etc. Thanks, Dave
by: Vaudousi | last post by:
Hi All Asking help again. I am a casual user of Access. I have a simple application which works correctly under Access 2003. I tried it under 2007. One of the module refuses to work. I have : A table : PersonId, Name, Birthday ---- A form (frmBirthDay) which includes ActiveX MonthView (ctlCalendar) and a subform (frmBirthDaySub) which...
by: iheartvba | last post by:
Hi I am getting the following error when i click cmdFFR (See note1): Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE'. I can't figure out why this is. Spelling all seems to be correct. Public Dimensions are as follow: Option Compare Database Option Explicit Public cnn As ADODB.Connection Public rst As...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.